Table: schools_conference_history
Columns: school
location
mascot
county
enrollment
ihsaa_class_football_soccer
year_joined
previous_conference
year_left
conference_joined

Question: What is the highest enrollment for rochester community school?
SQL: SELECT MAX("enrollment") FROM schools_conference_history WHERE "school" = 'rochester community'

Question: What is the average enrollment that has hot dogs as the mascot, with a year joined later than 1926?
SQL: SELECT AVG("enrollment") FROM schools_conference_history WHERE "mascot" = 'hot dogs' AND "year_joined" > 1926

Question: What is the lowest enrollment that has Lafayette as the location?
SQL: SELECT MIN("enrollment") FROM schools_conference_history WHERE "location" = 'lafayette'