Table: ice_hockey_87
Columns: games
drawn
lost
points_difference
points

Question: How many Games have a Drawn larger than 0, and a Lost of 1?
SQL: SELECT COUNT("games") FROM ice_hockey_87 WHERE "drawn" > 0 AND "lost" = 1

Question: Which Points have a Drawn larger than 0, and a Lost larger than 1?
SQL: SELECT AVG("points") FROM ice_hockey_87 WHERE "drawn" > 0 AND "lost" > 1

Question: Which Drawn has a Lost larger than 0, and Points smaller than 11, and Games smaller than 7?
SQL: SELECT AVG("drawn") FROM ice_hockey_87 WHERE "lost" > 0 AND "points" < 11 AND "games" < 7