Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Nomeie o Contra do Local do campo da cervejaria, Bridgend?
 ###Tabelas: CREATE TABLE allied_ships (allied_ships_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Name VARCHAR, Flag VARCHAR, Tonnage (GRT) INT, Sunk by VARCHAR) CREATE TABLE federal_election_results (federal_election_results_id AUTO_INCREMENT PRIMARY KEY, Election INT, # of candidates nominated INT, # of seats won INT, # of total votes INT, % of popular vote VARCHAR) CREATE TABLE list_of_ships (list_of_ships_id AUTO_INCREMENT PRIMARY KEY, Kanji VARCHAR, Name (Translation) VARCHAR, Builder VARCHAR, Laid down VARCHAR, Launched VARCHAR, Completed VARCHAR) CREATE TABLE regions (regions_id AUTO_INCREMENT PRIMARY KEY, In English VARCHAR, In Finnish VARCHAR, In Swedish VARCHAR, Capital VARCHAR, Regional state administrative agency VARCHAR) CREATE TABLE matches (matches_id AUTO_INCREMENT PRIMARY KEY, Opposing Team VARCHAR, Against INT, Date VARCHAR, Venue VARCHAR, Status VARCHAR)  
SELECT Against FROM matches WHERE Venue = brewery field , bridgend