What is the enrollment for Foote Field?
CREATE TABLE table_12896884_1 (enrollment INTEGER, football_stadium VARCHAR)
SELECT MAX(enrollment) FROM table_12896884_1 WHERE football_stadium = "Foote Field"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_12896884_1 (enrollment INTEGER, football_stadium VARCHAR) Question: What is the enrollment for Foote Field? [/INST] SELECT MAX(enrollment) FROM table_12896884_1 WHERE football_stadium = "Foote Field" </s>