Table: league_stats_10
Columns: position
team
points
played
drawn
lost
against
difference

Question: What is the average number played of the team with 1 drawn and 24 against?
SQL: SELECT AVG("played") FROM league_stats_10 WHERE "drawn" = 1 AND "against" = 24

Question: What is the highest lost number of the team with less than 14 points and less than 18 played?
SQL: SELECT MAX("lost") FROM league_stats_10 WHERE "points" < 14 AND "played" < 18

Question: Which team had 1 position?
SQL: SELECT "team" FROM league_stats_10 WHERE "position" = 1

Question: What is the lowest number of played of the team with 18 points and a position greater than 5?
SQL: SELECT MIN("played") FROM league_stats_10 WHERE "points" = 18 AND "position" > 5

Question: What is the total number of points of the team with less than 4 drawn and an against of 34?
SQL: SELECT COUNT("points") FROM league_stats_10 WHERE "drawn" < 4 AND "against" = 34

Question: What is the average number of drawn with a difference of 17 and 22 points?
SQL: SELECT AVG("drawn") FROM league_stats_10 WHERE "difference" = '17' AND "points" = 22