What is the highest week of the game on November 9, 1997?
CREATE TABLE table_41798 (
    "Week" real,
    "Date" text,
    "Opponent" text,
    "Result" text,
    "Record" text,
    "Location" text,
    "Attendance" text
)
SELECT MAX("Week") FROM table_41798 WHERE "Date" = 'november 9, 1997'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the highest week of the game on November 9, 1997? ### Input: CREATE TABLE table_41798 (
    "Week" real,
    "Date" text,
    "Opponent" text,
    "Result" text,
    "Record" text,
    "Location" text,
    "Attendance" text
) ### Response: SELECT MAX("Week") FROM table_41798 WHERE "Date" = 'november 9, 1997'