CREATE TABLE table_64908 ("School" CLOB, "City" CLOB, "Team Name" CLOB, "County" CLOB, "Year Joined" CLOB, "Year Left" CLOB)

Which school comes from Brookville?
SELECT "School" FROM table_64908 WHERE "City" = 'brookville'
SELECT "School" FROM "table_64908" WHERE "City" = 'brookville'