Table: collegiate_hockey_teams_2
Columns: institution
location
team_nickname
joined_tschl
home_arena
capacity
team_website

Question: How many schools have the team nickname bobcats? 
SQL: SELECT COUNT("institution") FROM collegiate_hockey_teams_2 WHERE "team_nickname" = 'Bobcats'

Question: Which city has the team nickname bearcats? 
SQL: SELECT "location" FROM collegiate_hockey_teams_2 WHERE "team_nickname" = 'Bearcats'

Question: What year did the university of Pittsburgh school join the hockey league? 
SQL: SELECT "joined_tschl" FROM collegiate_hockey_teams_2 WHERE "institution" = 'University of Pittsburgh'

Question: What's the earliest year anybody joined the hockey league? 
SQL: SELECT MIN("joined_tschl") FROM collegiate_hockey_teams_2

Question: Which city has the cincinnati hockey website?
SQL: SELECT "location" FROM collegiate_hockey_teams_2 WHERE "team_website" = 'Cincinnati Hockey'

Question: For the flyers, what's the minimum capacity? 
SQL: SELECT MIN("capacity") FROM collegiate_hockey_teams_2 WHERE "team_nickname" = 'Flyers'