CREATE TABLE table_name_40 (attendance NUMBER, date VARCHAR2)

on april 9 what was the attendance?
SELECT AVG(attendance) FROM table_name_40 WHERE date = "april 9"
SELECT AVG("attendance") FROM "table_name_40" WHERE "april 9" = "date"