user: Question: When hamilton academical is the Opponent, what is the total Attendance?
Columns: ['Round', 'Date', 'Opponent', 'Score', 'Aberdeen Scorer(s)', 'Attendance', 'Report']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['R4', '12 January', 'Falkirk', '2–2', 'Smith (4), Lovell (10)', 5798.0, 'BBC Sport']
SQL:

assistant: SELECT SUM("Attendance") FROM "Table" WHERE "Opponent" = 'hamilton academical';