Table: bavarian_ice_hockey_season_4
Columns: position
name
played
drawn
lost
points

Question: what is the average points when position is more than 5 and played is less than 10?
SQL: SELECT AVG("points") FROM bavarian_ice_hockey_season_4 WHERE "position" > 5 AND "played" < 10

Question: what is the average points when drawn is 0, lost is 5 and played is more than 10?
SQL: SELECT AVG("points") FROM bavarian_ice_hockey_season_4 WHERE "drawn" = 0 AND "lost" = 5 AND "played" > 10

Question: what is the average number lost when points is 14 and position is more than 1?
SQL: SELECT AVG("lost") FROM bavarian_ice_hockey_season_4 WHERE "points" = 14 AND "position" > 1

Question: what is the average points when played is 9, name is ev pegnitz and position is larger than 1?
SQL: SELECT AVG("points") FROM bavarian_ice_hockey_season_4 WHERE "played" = 9 AND "name" = 'ev pegnitz' AND "position" > 1