CREATE TABLE table_name_17 (attendance VARCHAR(255), venue VARCHAR(255))
What was the attendance for St Andrew's?
    
SQL: SELECT attendance FROM table_name_17 WHERE venue = "st andrew's"