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

Question: What is the nickname of the Adrian, Michigan team?
SQL: SELECT "team_nickname" FROM college_hockey_teams_2 WHERE "location" = 'Adrian, Michigan'

Question: How many primary conferences were held in Allendale, Michigan?
SQL: SELECT COUNT("primary_conference") FROM college_hockey_teams_2 WHERE "location" = 'Allendale, Michigan'

Question: Where is Robert Morris University-Illinois held?
SQL: SELECT "location" FROM college_hockey_teams_2 WHERE "institution" = 'Robert Morris University-Illinois'

Question: What is the enrollment for the Redhawks?
SQL: SELECT COUNT("enrollment") FROM college_hockey_teams_2 WHERE "team_nickname" = 'RedHawks'