Table: ice_hockey_champs_1997
Columns: games
drawn
lost
points_difference
points

Question: How many Games has Points larger than 0 and a Lost smaller than 4?
SQL: SELECT COUNT("games") FROM ice_hockey_champs_1997 WHERE "points" > 0 AND "lost" < 4 AND "drawn" < 0

Question: which Points has Games smaller than 7?
SQL: SELECT MAX("points") FROM ice_hockey_champs_1997 WHERE "games" < 7

Question: How many Drawns have Points smaller than 5 and a Lost larger than 7?
SQL: SELECT COUNT("drawn") FROM ice_hockey_champs_1997 WHERE "points" < 5 AND "lost" > 7