Table: great_lakes_collegiate_hockey
Columns: institution
location
founded
affiliation
enrollment
team_nickname
primary_conference

Question: What is the lowest enrollment for Eastern Michigan University?
SQL: SELECT MIN("enrollment") FROM great_lakes_collegiate_hockey WHERE "institution" = 'Eastern Michigan University'

Question: What is Kent State University's team nickname?
SQL: SELECT "team_nickname" FROM great_lakes_collegiate_hockey WHERE "institution" = 'Kent State University'

Question: How many Kent State University's are there?
SQL: SELECT COUNT("location") FROM great_lakes_collegiate_hockey WHERE "institution" = 'Kent State University'

Question: How many school teams are nicknamed "Bulldogs".
SQL: SELECT "location" FROM great_lakes_collegiate_hockey WHERE "team_nickname" = 'Bulldogs'