Table: collegiate_hockey_teams
Columns: school
location
founded
affiliation
enrollment
team_nickname
primary_conference

Question: How many schools are in Bloomington, IN?
SQL: SELECT COUNT("founded") FROM collegiate_hockey_teams WHERE "location" = 'Bloomington, IN'

Question: How many of the schools are designated private/Presbyterian?
SQL: SELECT COUNT("location") FROM collegiate_hockey_teams WHERE "affiliation" = 'Private/Presbyterian'

Question: In what year was Lindenwood University founded?
SQL: SELECT MIN("founded") FROM collegiate_hockey_teams WHERE "school" = 'Lindenwood University'

Question: How many of the schools listed are in Ames, IA?
SQL: SELECT COUNT("primary_conference") FROM collegiate_hockey_teams WHERE "location" = 'Ames, IA'