user: ### NOW ANSWER:
Question: What is the attendance when Cork City is the opponent?
Columns: ['Date', 'Opponents', 'H / A', 'Result F – A', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['1 August 1990', 'Bury', 'A', '0 – 0', 7162.0]
SQL:

assistant: SELECT AVG("Attendance") FROM "Table" WHERE "Opponents" = 'Cork City';