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: Nomeie os espectadores para 11 de novembro de 2011.
 ###Tabelas: CREATE TABLE club_world_cup_finalists_by_nation (club_world_cup_finalists_by_nation_id AUTO_INCREMENT PRIMARY KEY, Nation VARCHAR, Finalists INT, Winners INT, Runners-up INT, % won INT, Years won VARCHAR) CREATE TABLE college_statistics (college_statistics_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Rebs INT, Asts INT, Stls INT, Blks INT) CREATE TABLE list_of_housing_and_construction_ministers (list_of_housing_and_construction_ministers_id AUTO_INCREMENT PRIMARY KEY, Minister VARCHAR, Party VARCHAR, Governments VARCHAR, Term start VARCHAR, Term end VARCHAR) CREATE TABLE 2008-09_table (2008-09_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 turkish_national_team (turkish_national_team_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Time ( CEST ) INT, Team #1 VARCHAR, Res. VARCHAR, Team #2 VARCHAR, Round VARCHAR, Spectators INT)  
SELECT Spectators FROM turkish_national_team WHERE Date = 11 november 2011