CREATE TABLE table_name_78 (week INT, date VARCHAR)

What week has a Date of October 4, 1992?
SELECT SUM(week) FROM table_name_78 WHERE date = "october 4, 1992"
SELECT SUM("week") FROM "table_name_78" WHERE "date" = "october 4, 1992"