Schema: CREATE TABLE table_name_31 (attendance INTEGER, date VARCHAR)
Question: What was the attendance on 10 november 2004?
SQL: SELECT AVG(attendance) FROM table_name_31 WHERE date = "10 november 2004"