Table: bavarian_ice_hockey_season_2
Columns: position
name
played
drawn
lost
points

Question: What is the most elevated Played that has a Lost smaller than 12, and a Name of ec amberg (n), and a Position smaller than 4?
SQL: SELECT MAX("played") FROM bavarian_ice_hockey_season_2 WHERE "lost" < 12 AND "name" = 'ec amberg (n)' AND "position" < 4

Question: What is the average Lost that has a Name of ec amberg (n), and a Position smaller than 4?
SQL: SELECT AVG("lost") FROM bavarian_ice_hockey_season_2 WHERE "name" = 'ec amberg (n)' AND "position" < 4

Question: What is the whole of Points that has a Drawn smaller than 1?
SQL: SELECT SUM("points") FROM bavarian_ice_hockey_season_2 WHERE "drawn" < 1

Question: What is the whole of Drawn that has a Lost of 4?
SQL: SELECT SUM("drawn") FROM bavarian_ice_hockey_season_2 WHERE "lost" = 4

Question: What is the whole of Drawn that has a Played larger than 14?
SQL: SELECT SUM("drawn") FROM bavarian_ice_hockey_season_2 WHERE "played" > 14