CREATE TABLE table_name_40 (attendance INT, date VARCHAR)

What was the average attendance on October 12?
SELECT AVG(attendance) FROM table_name_40 WHERE date = "october 12"
SELECT AVG("attendance") FROM "table_name_40" WHERE "date" = "october 12"