DId the school with an enrollment of 50 have football?
CREATE TABLE "list_of_member_schools" (
  "school" text,
  "team_name" text,
  "town" text,
  "county" text,
  "school_enrollment_2008_10" real,
  "football" text
);
SELECT "football" FROM "list_of_member_schools" WHERE "school_enrollment_2008_10"=50;