user: ### NOW ANSWER:
Question: What is the enrollment for Foote Field?
Columns: ['Institution', 'Team', 'City', 'Province', 'First season', 'Head coach', 'Enrollment', 'Endowment', 'Football stadium', 'Capacity']
Types: ['text', 'text', 'text', 'text', 'real', 'text', 'real', 'text', 'text', 'real']
Sample row: ['University of British Columbia', 'Thunderbirds', 'Vancouver', 'BC', 1923.0, 'Shawn Olson', 43579.0, '$1.01B', 'Thunderbird Stadium', 3500.0]
SQL:

assistant: SELECT MAX("Enrollment") FROM "Table" WHERE "Football stadium" = 'Foote Field';