Table: terriers_hockey_stats
Columns: player
years
goals
assists
points

Question: What is the largest number of goals with less than 101 assists and 172 points?
SQL: SELECT MAX("goals") FROM terriers_hockey_stats WHERE "assists" < 101 AND "points" < 172

Question: How many total points does Mike Hyndman have with more than 119 assists?
SQL: SELECT SUM("points") FROM terriers_hockey_stats WHERE "player" = 'mike hyndman' AND "assists" > 119

Question: How many assists does David Tomlinson have?
SQL: SELECT SUM("assists") FROM terriers_hockey_stats WHERE "player" = 'david tomlinson'

Question: How many points does Shawn Mceachern with less than 79 goals?
SQL: SELECT SUM("points") FROM terriers_hockey_stats WHERE "player" = 'shawn mceachern' AND "goals" < 79

Question: How many goals does Mike Eruzione have in total?
SQL: SELECT "goals" FROM terriers_hockey_stats WHERE "player" = 'mike eruzione'