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

Question: How many goals for had a drawn more than 12 for the Goole Town team, as well as more than 60 goals against?
SQL: SELECT SUM("goals_for") FROM northern_league_stats_11 WHERE "drawn" > 12 AND "team" = 'goole town' AND "goals_against" > 60

Question: What are the average goals for with a drawn higher than 7 and goals against less than 86, as well as more than 11 losses and more than 42 games played?
SQL: SELECT AVG("goals_for") FROM northern_league_stats_11 WHERE "drawn" > 7 AND "goals_against" < 86 AND "lost" > 11 AND "played" > 42

Question: What is the highest lost with a drawn more than 11, a position lower than 17 and more than 61 goals?
SQL: SELECT MAX("lost") FROM northern_league_stats_11 WHERE "drawn" > 11 AND "position" < 17 AND "goals_for" > 61