Table: terriers_hockey_stats_2
Columns: player
years
games_played
goals_allowed
goals_against_average

Question: What is the average goals against average for those playing more than 78 games?
SQL: SELECT AVG("goals_against_average") FROM terriers_hockey_stats_2 WHERE "games_played" > 78

Question: Who played over 46 games and allowed less than 195 goals?
SQL: SELECT "player" FROM terriers_hockey_stats_2 WHERE "games_played" > 46 AND "goals_allowed" < 195

Question: Who played 44 games who averaged over 2.07 goals against?
SQL: SELECT "player" FROM terriers_hockey_stats_2 WHERE "goals_against_average" > 2.07 AND "games_played" = 44