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: Em que ano o Capital City Giants tiveram um jogo com o placar final de 8-0?
 ###Tabelas: CREATE TABLE game_results (game_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Game VARCHAR, Team VARCHAR, Runner-up VARCHAR, Score VARCHAR) CREATE TABLE referendum_on_prohibition (referendum_on_prohibition_id AUTO_INCREMENT PRIMARY KEY, Jurisdiction VARCHAR, For Prohibition INT, Percent For VARCHAR, Against Prohibition INT, Percent Against VARCHAR) CREATE TABLE local_rivals (local_rivals_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, League VARCHAR, Teams VARCHAR, Home VARCHAR, Away VARCHAR) CREATE TABLE mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up (mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mutya ng Pilipinas Asia Pacific VARCHAR, 1st runner-up VARCHAR, 2nd runner-up VARCHAR, 3rd runner-up VARCHAR, 4th runner-up VARCHAR) CREATE TABLE title_holders_from_2000_until_2010 (title_holders_from_2000_until_2010_id AUTO_INCREMENT PRIMARY KEY, Year INT, Miss Universe Philippines VARCHAR, Binibining Pilipinas-World VARCHAR, Binibining Pilipinas-International VARCHAR, Binibining Pilipinas-Tourism VARCHAR, First runner-up VARCHAR, Second runner-up VARCHAR)  
SELECT AVG Year FROM game_results WHERE Team = capital city giants AND Score = 8-0