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: Quantos jogos a equipe perdeu que jogou 7 jogos e tem um GA inferior a 27?
 ###Tabelas: CREATE TABLE league_round (league_round_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Played INT, Drawn INT, Lost INT, Points INT) CREATE TABLE discontinued_models (discontinued_models_id AUTO_INCREMENT PRIMARY KEY, Maker VARCHAR, Model VARCHAR, Intro year VARCHAR, Screen size (inch) VARCHAR, Self-lit VARCHAR, Screen type VARCHAR, Screen pixels VARCHAR) CREATE TABLE final_standing (final_standing_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Games Played INT, Wins INT, Losses INT, Ties INT, Goals For INT, Goals Against INT) CREATE TABLE summary_of_election_results_1973_-_2003 (summary_of_election_results_1973_-_2003_id AUTO_INCREMENT PRIMARY KEY, Election INT, Labour INT, Conservative INT, Liberal INT, Social Democratic Party INT, Social and Liberal Democrats/ Liberal Democrats INT, Independent INT, Green INT, Other VARCHAR, Control VARCHAR) CREATE TABLE population_area_and_density_sortable_on_each_field (population_area_and_density_sortable_on_each_field_id AUTO_INCREMENT PRIMARY KEY, Province VARCHAR, Population (2004 estimate) INT, Area (km²) INT, Density VARCHAR, GDP (2003, PPS in mil. € ) INT, GDP per cap. (2003, in €) INT)  
SELECT COUNT Losses FROM final_standing WHERE Games Played = 7 AND Goals Against < 27