Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
How many people in total attended the game on 1 november 1997?

### Inputs:
table_name: table, columns: ['Date', 'Opponents', 'Result F–A', 'Attendance', 'League position']

### Response:
SELECT COUNT Attendance FROM table WHERE Date = 1 november 1997