user: Question: When the venue wAs A And the dAte wAs 2 January 2008, 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" = '2 January 2008';