Table: mohawks_stats
Columns: season
games
lost
tied
points
goals_for
goals_against
coach

Question: What is the points average when the tied is greater than 8, less than 82 games and the coach of Bryan Mclay † Morris Lallo ‡ Gerry Moore ‡, and greater than 322 goals?
SQL: SELECT AVG("points") FROM mohawks_stats WHERE "tied" > 8 AND "games" < 82 AND "coach" = 'bryan mclay † morris lallo ‡ gerry moore ‡' AND "goals_against" > 322

Question: What are the most games when the points are 100 and goals for less than 356?
SQL: SELECT MAX("games") FROM mohawks_stats WHERE "points" = 100 AND "goals_for" < 356

Question: What is the most points when the goals against are 354 and games less than 82?
SQL: SELECT MAX("points") FROM mohawks_stats WHERE "goals_against" = 354 AND "games" < 82

Question: For games less than 70 and goals for greater than 335 what is the most points?
SQL: SELECT MAX("points") FROM mohawks_stats WHERE "goals_for" > 335 AND "games" < 70