Table: vermont_colleges
Columns: school
location_s
control
type
enrollment_2009
founded

Question: What are the public schools with a master's university?
SQL: SELECT "location_s" FROM vermont_colleges WHERE "control" = 'Public' AND "type" = 'Master''s university'

Question: What is the minimum enrollment for Plainfield?
SQL: SELECT MIN("enrollment_2009") FROM vermont_colleges WHERE "location_s" = 'Plainfield'

Question: What type of school had an enrollment in 2009 of 224?
SQL: SELECT "type" FROM vermont_colleges WHERE "enrollment_2009" = 224

Question: When was Southern Vermont College founded?
SQL: SELECT MAX("founded") FROM vermont_colleges WHERE "school" = 'Southern Vermont College'

Question: Is art school public or private?
SQL: SELECT "control" FROM vermont_colleges WHERE "type" = 'Art school'

Question: What school was founded in 1791?
SQL: SELECT "school" FROM vermont_colleges WHERE "founded" = 1791