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: Qual é a média de gols sofridos para aqueles que jogam mais de 78 partidas?
 ###Tabelas: CREATE TABLE senior (senior_id AUTO_INCREMENT PRIMARY KEY, Year INT, Competition VARCHAR, Venue VARCHAR, Position VARCHAR, Event VARCHAR) CREATE TABLE goaltending_leaders (goaltending_leaders_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Years VARCHAR, Games played INT, Goals allowed INT, Goals against average INT) CREATE TABLE wct_1985 (wct_1985_id AUTO_INCREMENT PRIMARY KEY, Date Final VARCHAR, Tournament VARCHAR, Commercial Name VARCHAR, Category VARCHAR, Prize Money/ Surface VARCHAR, Final Match VARCHAR, Semifinal Matches VARCHAR) CREATE TABLE racial_composition (racial_composition_id AUTO_INCREMENT PRIMARY KEY, Municipality (2010) VARCHAR, White (both Hispanic and Non-Hispanic) INT, Black (Both Hispanic and Non-Hispanic) INT, Amerindian (Both Hispanic and Non-Hispanic) INT, n Asia (Both Hispanic and Non-Hispanic) INT, Multiracial (Both Hispanic and Non-Hispanic) INT, Hispanic (Of any Race) INT) CREATE TABLE line_honours_results_top_10 (line_honours_results_top_10_id AUTO_INCREMENT PRIMARY KEY, Position INT, Race number VARCHAR, Sail number VARCHAR, Yacht VARCHAR, State/country VARCHAR, Yacht type VARCHAR, LOA (Metres) VARCHAR, Skipper VARCHAR, Elapsed time d:hh:mm:ss VARCHAR)  
SELECT AVG Goals against average FROM goaltending_leaders WHERE Games played > 78