Table: miac_colleges
Columns: institution
nickname
location_all_in_minnesota
founded
type
enrollment
joined

Question: What institution is located in St. Peter? 
SQL: SELECT "institution" FROM miac_colleges WHERE "location_all_in_minnesota" = 'St. Peter'

Question: What is the enrollment for Augsburg college? 
SQL: SELECT MIN("enrollment") FROM miac_colleges WHERE "institution" = 'Augsburg College'

Question: What was the earliest date an institution was founded that joined in 1977? 
SQL: SELECT MIN("founded") FROM miac_colleges WHERE "joined" = '1977'