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

Question: What is the fewest number of games lost?
SQL: SELECT MIN("lost") FROM northern_league_stats

Question: What is the goal average 1 for teams that lost 9 games?
SQL: SELECT "goal_average_1" FROM northern_league_stats WHERE "lost" = 9

Question: How many teams finished with a 2nd points total of 31?
SQL: SELECT COUNT("position") FROM northern_league_stats WHERE "points_2" = 31

Question: How many games drawn for the team that had 72 goals for?
SQL: SELECT MAX("drawn") FROM northern_league_stats WHERE "goals_for" = 72