user: Question: How man seasons have the air date of October 2, 2001? 
Columns: ['Series #', 'Season #', 'Title', 'Director', 'Writer(s)', 'NBC Airdate', 'Code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: [23.0, 1.0, '"Phoenix"', 'Michael Robison', 'Carl Binder', 'July 13, 2001', 201.0]
SQL:

assistant: SELECT COUNT("Season #") FROM "Table" WHERE "NBC Airdate" = 'October 2, 2001';