Table: northern_league_stats_4
Columns: position
team
played
drawn
lost
goals_for
goals_against
goal_average_1
points_2

Question: Which Goals Against has a Drawn larger than 9, a Lost larger than 15, a Position of 24, and a Played smaller than 46?
SQL: SELECT AVG("goals_against") FROM northern_league_stats_4 WHERE "drawn" > 9 AND "lost" > 15 AND "position" = 24 AND "played" < 46

Question: Which Points 2 has Drawn of 15, a Position larger than 20, and a Goals For smaller than 45?
SQL: SELECT SUM("points_2") FROM northern_league_stats_4 WHERE "drawn" = 15 AND "position" > 20 AND "goals_for" < 45

Question: Which Goals For has a Position larger than 2, a Lost larger than 18, a Team of matlock town, and a Goals Against larger than 79?
SQL: SELECT MAX("goals_for") FROM northern_league_stats_4 WHERE "position" > 2 AND "lost" > 18 AND "team" = 'matlock town' AND "goals_against" > 79

Question: Which Points 2 has a Goal Average 1 larger than 1.17, a Goals Against larger than 48, and a Position larger than 6?
SQL: SELECT SUM("points_2") FROM northern_league_stats_4 WHERE "goal_average_1" > 1.17 AND "goals_against" > 48 AND "position" > 6