Table: bavarian_ice_hockey_2008
Columns: position
name
played
drawn
lost
points

Question: What is the total number for the position that has less than 2 draws, less than 9 losses and more than 24?
SQL: SELECT COUNT("position") FROM bavarian_ice_hockey_2008 WHERE "drawn" < 2 AND "lost" < 9 AND "points" > 24

Question: What is the highest played with more than 0 draws, less than 3 losses, and less than 27 points?
SQL: SELECT MAX("played") FROM bavarian_ice_hockey_2008 WHERE "drawn" > 0 AND "lost" < 3 AND "points" < 27

Question: What is the total number played with 8 points and a position more than 6?
SQL: SELECT COUNT("played") FROM bavarian_ice_hockey_2008 WHERE "points" = 8 AND "position" > 6

Question: What is the total number played with 1 drawn, and less than 7 points?
SQL: SELECT COUNT("played") FROM bavarian_ice_hockey_2008 WHERE "drawn" = 1 AND "points" < 7