CREATE TABLE table_name_31 (attendance NUMBER, date VARCHAR2)

What was the attendance on 10 november 2004?
SELECT AVG(attendance) FROM table_name_31 WHERE date = "10 november 2004"
SELECT AVG("attendance") FROM "table_name_31" WHERE "10 november 2004" = "date"