Which school comes from Brookville?
CREATE TABLE "former_members" (
  "school" text,
  "city" text,
  "team_name" text,
  "county" text,
  "year_joined" text,
  "year_left" text
);
SELECT "school" FROM "former_members" WHERE "city"='brookville';