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 corridas ocorreram em 1 de outubro?
 ###Tabelas: CREATE TABLE by_teams (by_teams_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Winners INT, Runners-up INT, Years won VARCHAR, Years runners-up VARCHAR) CREATE TABLE dfb_cup_appearances (dfb_cup_appearances_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Round VARCHAR, Date VARCHAR, Home VARCHAR, Away VARCHAR, Result VARCHAR) CREATE TABLE active_teams (active_teams_id AUTO_INCREMENT PRIMARY KEY, Tournament Appearances INT, Team VARCHAR, League VARCHAR, Wins INT, Final Losses INT, Semi-Final Losses INT, Fourth-Place* INT, Final Win % VARCHAR, Years of appearance VARCHAR) CREATE TABLE 2007_2008_table (2007_2008_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) CREATE TABLE schedule_and_results (schedule_and_results_id AUTO_INCREMENT PRIMARY KEY, Rnd INT, Date VARCHAR, Race Name VARCHAR, Length VARCHAR, Track VARCHAR, Location VARCHAR, Type VARCHAR, Pole Position VARCHAR, Winning Driver VARCHAR)  
SELECT COUNT Race Name FROM schedule_and_results WHERE Date = October 1