CREATE TABLE table_39971 ("Date" CLOB, "Opponent" CLOB, "Venue" CLOB, "Result" CLOB, "Attendance" FLOAT)

On 1 september 2007, at the Venue A, what was the average attendance?
SELECT AVG("Attendance") FROM table_39971 WHERE "Venue" = 'a' AND "Date" = '1 september 2007'
SELECT AVG("Attendance") FROM "table_39971" WHERE "Date" = '1 september 2007' AND "Venue" = 'a'