user: ### NOW ANSWER:
Question: How many people in total attended the game on 1 november 1997?
Columns: ['Date', 'Opponents', 'Result F–A', 'Attendance', 'League position']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['10 August 1997', 'Tottenham Hotspur', '2–0', 26359.0, '1st']
SQL:

assistant: SELECT COUNT("Attendance") FROM "Table" WHERE "Date" = '1 november 1997';