Table: league_stats_2006
Columns: position
club
played
wins
draws
losses
goals_for
goals_against
points
goal_difference

Question: Can you tell me the sum of Wins that has the Club of abuls smiltene, and the Goals smaller than 18?
SQL: SELECT SUM("wins") FROM league_stats_2006 WHERE "club" = 'abuls smiltene' AND "goals_for" < 18

Question: Can you tell me the average Wins that has the Goal Difference larger than -24, and the Draws larger than 7?
SQL: SELECT AVG("wins") FROM league_stats_2006 WHERE "goal_difference" > -24 AND "draws" > 7

Question: Can you tell me the highest Draws that has the Goal Difference smaller than 64, and the Played larger than 30?
SQL: SELECT MAX("draws") FROM league_stats_2006 WHERE "goal_difference" < 64 AND "played" > 30

Question: Can you tell me the highest Points that has the Played smaller than 30?
SQL: SELECT MAX("points") FROM league_stats_2006 WHERE "played" < 30