user: ### NOW ANSWER:
Question: What school is in Brookville?
Columns: ['School', 'City', 'Team Name', 'Enrollment', 'IHSAA Class', 'IHSAA Football Class', 'County']
Types: ['text', 'text', 'text', 'real', 'text', 'text', 'text']
Sample row: ['Batesville', 'Batesville', 'Bulldogs', 676.0, 'AAA', 'AAA', '69 Ripley']
SQL:

assistant: SELECT "School" FROM "Table" WHERE "City" = 'Brookville';