user: ### NOW ANSWER:
Question: On 1 September 2007, At the Venue A, whAt wAs the AverAge AttendAnce?
Columns: ['Date', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['4 August 2007', 'Airdrie United', 'A', '1–0', 1645.0]
SQL:

assistant: SELECT AVG("Attendance") FROM "Table" WHERE "Venue" = 'A' AND "Date" = '1 September 2007';