CREATE TABLE table_name_55 (week INT, date VARCHAR)

What week was September 24, 2000 on?
SELECT SUM(week) FROM table_name_55 WHERE date = "september 24, 2000"
SELECT SUM("week") FROM "table_name_55" WHERE "date" = "september 24, 2000"