Table: northern_league_stats_15
Columns: position
team
played
drawn
lost
goals_for
goals_against
goal_difference
points_1

Question: How many played when lost is more than 17, drawn is 15 and goals against is less than 75?
SQL: SELECT AVG("played") FROM northern_league_stats_15 WHERE "lost" > 17 AND "drawn" = 15 AND "goals_against" < 75

Question: what is the position when lot is less than 14, goal difference is +1 and drawn is more than 15?
SQL: SELECT SUM("position") FROM northern_league_stats_15 WHERE "lost" < 14 AND "goal_difference" = '+1' AND "drawn" > 15

Question: How many lost when goals for is 43 and the position number is higher than 15?
SQL: SELECT AVG("lost") FROM northern_league_stats_15 WHERE "goals_for" = 43 AND "position" > 15