CREATE TABLE table_name_47 (attendance VARCHAR2, date VARCHAR2)

What was the attendance on August 8?
SELECT attendance FROM table_name_47 WHERE date = "august 8"
SELECT "attendance" FROM "table_name_47" WHERE "august 8" = "date"