Table: tennessee_oilers_1997
Columns: week
date
opponent
result
record
location
attendance

Question: What is the highest week of the game on November 9, 1997?
SQL: SELECT MAX("week") FROM tennessee_oilers_1997 WHERE "date" = 'november 9, 1997'