Table: college_hockey_teams
Columns: school
location
founded
affiliation
enrollment
nickname
primary_conference

Question: Name the maximum enrollment for niagara university
SQL: SELECT MAX("enrollment") FROM college_hockey_teams WHERE "school" = 'Niagara University'

Question: Name the primary conference for st. bonaventure university
SQL: SELECT "primary_conference" FROM college_hockey_teams WHERE "school" = 'St. Bonaventure University'

Question: Name the total number of nicknames for st. bonaventure university
SQL: SELECT COUNT("nickname") FROM college_hockey_teams WHERE "school" = 'St. Bonaventure University'

Question: Name the total number of affiliation for enrollment being 14898
SQL: SELECT COUNT("affiliation") FROM college_hockey_teams WHERE "enrollment" = 14898