CREATE TABLE table_name_52 (week NUMBER, date VARCHAR2)

Which Week has a Date of october 4, 1992?
SELECT MAX(week) FROM table_name_52 WHERE date = "october 4, 1992"
SELECT MAX("week") FROM "table_name_52" WHERE "date" = "october 4, 1992"