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

Question: How many goals have Lost larger than 35, and Games smaller than 80?
SQL: SELECT COUNT("goals_for") FROM lowell_devils_stats WHERE "lost" > 35 AND "games" < 80

Question: What are the total Goals against with 72 points and more than 37 losses?
SQL: SELECT SUM("goals_against") FROM lowell_devils_stats WHERE "points" = 72 AND "lost" > 37

Question: What are the total number of points with more than 225 goals and a Goals against of 190?
SQL: SELECT SUM("points") FROM lowell_devils_stats WHERE "goals_for" > 225 AND "goals_against" = 190