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

Question: What is the highest losses for more than 11 wins, a goal difference greater than 5, a 3 position, and more than 3 draws?
SQL: SELECT MAX("losses") FROM segunda_division_stats_7 WHERE "wins" > 11 AND "goal_difference" > 5 AND "position" = 3 AND "draws" > 3

Question: What is the average points with less than 30 played?
SQL: SELECT AVG("points") FROM segunda_division_stats_7 WHERE "played" < 30

Question: What is the lowest amount of draws club ud lérida, which has less than 41 goals, has?
SQL: SELECT MIN("draws") FROM segunda_division_stats_7 WHERE "club" = 'ud lérida' AND "goals_for" < 41

Question: What is the total amount of points for a position less than 7, 68 goals for, and less than 30 played?
SQL: SELECT COUNT("points") FROM segunda_division_stats_7 WHERE "position" < 7 AND "goals_for" = 68 AND "played" < 30

Question: What is teh average amount of goals for club real avilés cf, which has more than 59 goals against and a -10 goal difference?
SQL: SELECT AVG("goals_for") FROM segunda_division_stats_7 WHERE "goals_against" > 59 AND "club" = 'real avilés cf' AND "goal_difference" > -10

Question: What is the average goal difference of club cultural leonesa, which has more than 27 points and less than 9 losses?
SQL: SELECT AVG("goal_difference") FROM segunda_division_stats_7 WHERE "points" > 27 AND "losses" < 9 AND "club" = 'cultural leonesa'