CREATE TABLE table_name_1 (week NUMBER, date VARCHAR2)

What is the highest week of the game on November 9, 1997?
SELECT MAX(week) FROM table_name_1 WHERE date = "november 9, 1997"
SELECT MAX("week") FROM "table_name_1" WHERE "date" = "november 9, 1997"