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

Question: W hat was the lowest Goals For when they played Team Goole Town and had a position lower than 9?
SQL: SELECT MIN("goals_for") FROM northern_league_stats_8 WHERE "team" = 'goole town' AND "position" < 9

Question: Which team has a position higher than 3, a Drawn lower than 12, and a Goals Against higher than 85?
SQL: SELECT "team" FROM northern_league_stats_8 WHERE "drawn" < 12 AND "position" > 3 AND "goals_against" > 85

Question: When the Points 1 were 44 and the Goals For were larger than 65, what was the total number of Goals Against?
SQL: SELECT COUNT("goals_against") FROM northern_league_stats_8 WHERE "points_1" = 44 AND "goals_for" > 65