CREATE TABLE table_name_45 (attendance INT, venue VARCHAR, date VARCHAR)

On 1 september 2007, at the Venue A, what was the average attendance?
SELECT AVG(attendance) FROM table_name_45 WHERE venue = "a" AND date = "1 september 2007"
SELECT AVG("attendance") FROM "table_name_45" WHERE "1 september 2007" = "date" AND "a" = "venue"