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 ganhos houve para o jogador que teve uma perda maior que 57 e um longo menor que 55?
 ###Tabelas: CREATE TABLE singles_titles (singles_titles_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Opponent in the final VARCHAR, Score VARCHAR) CREATE TABLE ohio_locations_ranked_by_per_capita_income (ohio_locations_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Place VARCHAR, County VARCHAR, Per Capita Income VARCHAR, Median House- hold Income VARCHAR, Population INT, Number of Households INT) CREATE TABLE rushing (rushing_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Gain INT, Loss INT, Long INT, Avg/G INT) CREATE TABLE top_20_countries_by_tally (top_20_countries_by_tally_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Country/Territory VARCHAR, Miss World INT, 1st Runner-up INT, 2nd Runner-up INT, 3rd Runner-up INT, 4th Runner-up INT, 5th Runner-up INT, 6th Runner-up INT, Semifinalists INT, Total INT) CREATE TABLE pga_tour_wins_8 (pga_tour_wins_8_id AUTO_INCREMENT PRIMARY KEY, No. INT, Date VARCHAR, Tournament VARCHAR, Winning score VARCHAR, To par VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR)  
SELECT COUNT Gain FROM rushing WHERE Loss > 57 AND Long < 55