Table: pv_football_schools
Columns: school
team_name
town
county
school_enrollment_2008_10
football

Question: DId the school with an enrollment of 50 have football?
SQL: SELECT "football" FROM pv_football_schools WHERE "school_enrollment_2008_10" = 50

Question: What is the highest number of school enrollment for Union Star High School in De Kalb county?
SQL: SELECT MAX("school_enrollment_2008_10") FROM pv_football_schools WHERE "county" = 'de kalb' AND "school" = 'union star high school'

Question: What school had a team name of the Trojans?
SQL: SELECT "school" FROM pv_football_schools WHERE "team_name" = 'trojans'