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

Question: Which Goal Difference has 28 Points, and a Club of cd cartagena, more than 15 losses?
SQL: SELECT MAX("goal_difference") FROM segunda_division_stats_8 WHERE "points" = 28 AND "club" = 'cd cartagena' AND "losses" > 15

Question: How much Goal Difference has less than 9 Losses, and 8 Draws, and more than 40 points?
SQL: SELECT SUM("goal_difference") FROM segunda_division_stats_8 WHERE "losses" < 9 AND "draws" = 8 AND "points" > 40

Question: How many points have more than 14 wins, a goal difference of 14, and more than 6 draws?
SQL: SELECT COUNT("points") FROM segunda_division_stats_8 WHERE "wins" > 14 AND "goal_difference" = 14 AND "draws" > 6

Question: Which Played has Goals against larger than 34, and Wins smaller than 12, and Goals for smaller than 50, and Losses larger than 15?
SQL: SELECT AVG("played") FROM segunda_division_stats_8 WHERE "goals_against" > 34 AND "wins" < 12 AND "goals_for" < 50 AND "losses" > 15

Question: Which Draws has Goals against smaller than 47, and a Position smaller than 13, and Goals for of 52?
SQL: SELECT MIN("draws") FROM segunda_division_stats_8 WHERE "goals_against" < 47 AND "position" < 13 AND "goals_for" = 52