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: Pergunta: Nomeie o número total de presenças para 8 de outubro.
 ###Tabelas: CREATE TABLE game_log (game_log_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Score VARCHAR, Loss VARCHAR, Attendance INT, Series VARCHAR) CREATE TABLE specifications_r-985_wasp_junior_sb (specifications_r-985_wasp_junior_sb_id AUTO_INCREMENT PRIMARY KEY, Engine VARCHAR, Power, continuous VARCHAR, Critical altitude This is the highest altitude at which the engine can achieve its full continuous power rating. Above this altitude, power falls off with height as with a naturally aspirated engine . See Supercharger#Altitude effects for details. VARCHAR, Power, takeoff VARCHAR, Compression ratio VARCHAR, Supercharger gear ratio VARCHAR, Octane rating VARCHAR, Dry weight VARCHAR) CREATE TABLE player_selections (player_selections_id AUTO_INCREMENT PRIMARY KEY, Rnd. VARCHAR, Pick # INT, NFL team VARCHAR, Pos. VARCHAR, College VARCHAR, Conf. VARCHAR) CREATE TABLE team_players_in_the_nfl (team_players_in_the_nfl_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Position VARCHAR, Round INT, Pick INT, NFL Club VARCHAR) CREATE TABLE highest_scoring_grand_finals (highest_scoring_grand_finals_id AUTO_INCREMENT PRIMARY KEY, Total Points INT, Score VARCHAR, Premiers VARCHAR, Runners Up VARCHAR, Details VARCHAR)  
SELECT COUNT Attendance FROM game_log WHERE Date = october 8