user: ### NOW ANSWER:
Question: What is the highest week of the game on November 9, 1997?
Columns: ['Week', 'Date', 'Opponent', 'Result', 'Record', 'Location', 'Attendance']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'August 31, 1997', 'Oakland Raiders', 'W 24–21', '1–0', 'Liberty Bowl Memorial Stadium', '30,171']
SQL:

assistant: SELECT MAX("Week") FROM "Table" WHERE "Date" = 'November 9, 1997';