user: ### NOW ANSWER:
Question: What was the attendance on 10 November 2004?
Columns: ['Date', 'Round', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['27 October 2004', 'R3', 'West Ham United', 'H', '1-0', 41774.0]
SQL:

assistant: SELECT AVG("Attendance") FROM "Table" WHERE "Date" = '10 November 2004';