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

Question: What is the average number of draws that has a played entry of less than 30 and a goal difference greater than 2?
SQL: SELECT AVG("draws") FROM segunda_division_standings_4 WHERE "goal_difference" > 2 AND "played" < 30

Question: What is the average number played that has fewer than 11 wins, more than 42 goals, more than 22 points, and 11 losses?
SQL: SELECT AVG("played") FROM segunda_division_standings_4 WHERE "wins" < 11 AND "goals_for" > 42 AND "points" > 22 AND "losses" = 11

Question: What is the total of the goal difference entries for entries with fewer than 49 goals and position smaller than 8?
SQL: SELECT COUNT("goal_difference") FROM segunda_division_standings_4 WHERE "goals_for" < 49 AND "position" < 8

Question: What is the lowest played for the entry with position of 2 and fewer than 9 losses?
SQL: SELECT MIN("played") FROM segunda_division_standings_4 WHERE "position" = 2 AND "losses" < 9

Question: What is the total number of losses for entries that have 12 wins and a goal difference smaller than -14?
SQL: SELECT COUNT("losses") FROM segunda_division_standings_4 WHERE "wins" = 12 AND "goal_difference" < -14