CREATE TABLE table_name_34 (attendance NUMBER, date VARCHAR2)

What's the average attendance on january 6, 2008?
SELECT AVG(attendance) FROM table_name_34 WHERE date = "january 6, 2008"
SELECT AVG("attendance") FROM "table_name_34" WHERE "date" = "january 6, 2008"