Table: north_carolina_colleges_universities
Columns: school
location_s
control
type
enrollment_2012
founded

Question: When east carolina university is the school what is the highest year founded?
SQL: SELECT MAX("founded") FROM north_carolina_colleges_universities WHERE "school" = 'East Carolina University'

Question: When 1927 is the founded year how many measurements of enrollment in 2012 are there?
SQL: SELECT COUNT("enrollment_2012") FROM north_carolina_colleges_universities WHERE "founded" = 1927

Question: When western carolina university is the school what is the control?
SQL: SELECT "control" FROM north_carolina_colleges_universities WHERE "school" = 'Western Carolina University'

Question: When university of north carolina at charlotte is the school what is the lowest enrollment in 2012?
SQL: SELECT MIN("enrollment_2012") FROM north_carolina_colleges_universities WHERE "school" = 'University of North Carolina at Charlotte'