What school had a team name of the Trojans?
CREATE TABLE "list_of_member_schools" (
  "school" text,
  "team_name" text,
  "town" text,
  "county" text,
  "school_enrollment_2008_10" real,
  "football" text
);
SELECT "school" FROM "list_of_member_schools" WHERE "team_name"='trojans';