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 o clube com 47 pontos teve?
 ###Tabelas: CREATE TABLE fourth_round_proper (fourth_round_proper_id AUTO_INCREMENT PRIMARY KEY, Tie no VARCHAR, Home team VARCHAR, Score VARCHAR, Away team VARCHAR, Date VARCHAR) CREATE TABLE member_schools (member_schools_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Nickname VARCHAR, Location VARCHAR, Founded INT, Joined ACC INT, School Type VARCHAR, ACC Football Titles INT) CREATE TABLE 2011_2012_table (2011_2012_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Tries against VARCHAR, Try bonus VARCHAR, Losing bonus VARCHAR, Points VARCHAR) CREATE TABLE doubles_7_4-3 (doubles_7_4-3_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE top_scorers_in_loi (top_scorers_in_loi_id AUTO_INCREMENT PRIMARY KEY, Ranking INT, Nationality VARCHAR, Name VARCHAR, Years VARCHAR, Goals INT)  
SELECT Lost FROM 2011_2012_table WHERE Points = 47