CREATE TABLE table_24846 ("Series #" FLOAT, "Season #" FLOAT, "Title" CLOB, "Director" CLOB, "Writer ( s ) " CLOB, "NBC Airdate" CLOB, "Code" FLOAT)

How man seasons have the air date of October 2, 2001?
SELECT COUNT("Season #") FROM table_24846 WHERE "NBC Airdate" = 'October 2, 2001'
SELECT COUNT("Season #") FROM "table_24846" WHERE "NBC Airdate" = 'October 2, 2001'