user: ### NOW ANSWER:
Question: Which school comes from Brookville?
Columns: ['School', 'City', 'Team Name', 'County', 'Year Joined', 'Year Left']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Aurora', 'Aurora', 'Red Devils', '15 Dearborn', '1956', '1978']
SQL:

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