When Hamilton Academical is the Opponent, what is the total Attendance?
CREATE TABLE table_name_26 (attendance VARCHAR, opponent VARCHAR)
SELECT COUNT(attendance) FROM table_name_26 WHERE opponent = "hamilton academical"
### Context: CREATE TABLE table_name_26 (attendance VARCHAR, opponent VARCHAR) ### Question: When Hamilton Academical is the Opponent, what is the total Attendance? ### Answer: SELECT COUNT(attendance) FROM table_name_26 WHERE opponent = "hamilton academical"