Table: nhl_season_stats
Columns: season
games
lost
tied
points
goals_for
goals_against
standing

Question: How many games have more than 288 goals and less than 34 losses?
SQL: SELECT COUNT("games") FROM nhl_season_stats WHERE "goals_against" > 288 AND "lost" < 34

Question: What is the lowest tie with less than 100 points and 277 goals?
SQL: SELECT MIN("tied") FROM nhl_season_stats WHERE "points" < 100 AND "goals_for" = 277