CREATE TABLE table_name_2 (week VARCHAR2, date VARCHAR2)

What week was October 29, 2000?
SELECT COUNT(week) FROM table_name_2 WHERE date = "october 29, 2000"
SELECT COUNT("week") FROM "table_name_2" WHERE "date" = "october 29, 2000"