Table: ice_hockey_1974
Columns: games
drawn
lost
points_difference
points

Question: What game has 2 points?
SQL: SELECT MAX("games") FROM ice_hockey_1974 WHERE "points" = 2

Question: How many total drawn has less than 4 lost and 8 points?
SQL: SELECT SUM("drawn") FROM ice_hockey_1974 WHERE "lost" < 4 AND "points" = 8

Question: How many lost are there before game 7?
SQL: SELECT SUM("lost") FROM ice_hockey_1974 WHERE "games" < 7