CREATE TABLE table_name_26 (attendance VARCHAR2, opponent VARCHAR2)

When Hamilton Academical is the Opponent, what is the total Attendance?
SELECT COUNT(attendance) FROM table_name_26 WHERE opponent = "hamilton academical"
SELECT COUNT("attendance") FROM "table_name_26" WHERE "hamilton academical" = "opponent"