user: ### NOW ANSWER:
Question: What is the average attendance for all events held at Palmerston Park venue?
Columns: ['Date', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['2 August 2008', 'Dunfermline Athletic', 'Firhill', '1-0', 3092.0]
SQL:

assistant: SELECT AVG("Attendance") FROM "Table" WHERE "Venue" = 'Palmerston Park';