CREATE TABLE table_name_17 (attendance VARCHAR2, venue VARCHAR2)

What was the attendance for St Andrew's?
SELECT attendance FROM table_name_17 WHERE venue = "st andrew's"
SELECT "attendance" FROM "table_name_17" WHERE "st andrew's" = "venue"