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: Quem jogou como Time 2 contra o Time 1 SC Gagnoa?
 ###Tabelas: CREATE TABLE second_round (second_round_id AUTO_INCREMENT PRIMARY KEY, Team 1 VARCHAR, Agg. VARCHAR, Team 2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR) CREATE TABLE specifications_r-985_wasp_junior_sb (specifications_r-985_wasp_junior_sb_id AUTO_INCREMENT PRIMARY KEY, Engine VARCHAR, Power, continuous VARCHAR, Critical altitude This is the highest altitude at which the engine can achieve its full continuous power rating. Above this altitude, power falls off with height as with a naturally aspirated engine . See Supercharger#Altitude effects for details. VARCHAR, Power, takeoff VARCHAR, Compression ratio VARCHAR, Supercharger gear ratio VARCHAR, Octane rating VARCHAR, Dry weight VARCHAR) CREATE TABLE doubles_2–4 (doubles_2–4_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE new_york_counties_ranked_by_per_capita_income (new_york_counties_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT) CREATE TABLE provinces (provinces_id AUTO_INCREMENT PRIMARY KEY, Province VARCHAR, Provincial capital VARCHAR, Largest city VARCHAR, Area (km 2 ) INT, Population (2013) INT)  
SELECT Team 2 FROM second_round WHERE Team 1 = sc gagnoa