user: ### NOW ANSWER:
Question: Which week starts on November 23, 1997?
Columns: ['Week', 'Date', 'Location', 'Opponent', 'Result']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'August 31, 1997', 'Foxboro Stadium', 'San Diego Chargers', 'W 41–7']
SQL:

assistant: SELECT "Week" FROM "Table" WHERE "Date" = 'November 23, 1997';