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

Question: How many points has more than 15 wins and less than 10 losses?
SQL: SELECT "points" FROM segunda_division_stats_4 WHERE "wins" > 15 AND "losses" < 10

Question: What is the total goal difference with more than 38 played and more than 47 goals against?
SQL: SELECT SUM("goal_difference") FROM segunda_division_stats_4 WHERE "goals_against" > 47 AND "played" > 38

Question: What is the average draws with more than 38 played?
SQL: SELECT AVG("draws") FROM segunda_division_stats_4 WHERE "played" > 38