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: Quantas derrotas têm 222 como gols sofridos, com pontos maiores que 78?
 ###Tabelas: CREATE TABLE by_name (by_name_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Country VARCHAR, Seasons VARCHAR, Championship Titles VARCHAR, Race entries (Starts) VARCHAR, Poles INT, Wins INT, Podiums INT, Fastest Laps INT, Points VARCHAR) CREATE TABLE university_location_date_established (university_location_date_established_id AUTO_INCREMENT PRIMARY KEY, University VARCHAR, Location VARCHAR, Established INT, Endowment as of 2008 VARCHAR, Campus Area (acres) INT, Kiplinger's Top 100 Values VARCHAR, Enrollment as of 2008 INT) CREATE TABLE most_prominent_summits (most_prominent_summits_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Mountain Peak VARCHAR, Province VARCHAR, Mountain Range VARCHAR, Location VARCHAR) CREATE TABLE screen_actors_guild (screen_actors_guild_id AUTO_INCREMENT PRIMARY KEY, Year INT, Category VARCHAR, Film VARCHAR, Result VARCHAR, Lost to VARCHAR) CREATE TABLE season-by-season_results (season-by-season_results_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Games INT, Lost INT, Tied VARCHAR, Points INT, Pct % INT, Goals for INT, Goals against INT, Penalty minutes INT)  
SELECT SUM Lost FROM season-by-season_results WHERE Goals against = 222 AND Points > 78