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

Question: What affiliation is Erie, Pennsylvania?
SQL: SELECT "affiliation" FROM college_hockey_teams WHERE "location" = 'Erie, Pennsylvania'

Question: What was the enrollment of the school founded in 1846?
SQL: SELECT "enrollment" FROM college_hockey_teams WHERE "founded" = 1846

Question: What kind of school is Canton, New York?
SQL: SELECT "affiliation" FROM college_hockey_teams WHERE "location" = 'Canton, New York'