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

Question: what is the lost when played is less than 42?
SQL: SELECT SUM("lost") FROM northern_league_stats_9 WHERE "played" < 42

Question: what is the goal difference when drawn is more than 11, goals against is less than 63, goals for is less than 87 and lost is more than 16?
SQL: SELECT "goal_difference" FROM northern_league_stats_9 WHERE "drawn" > 11 AND "goals_against" < 63 AND "goals_for" < 87 AND "lost" > 16

Question: how many times is lost less than 7 and the position 2?
SQL: SELECT COUNT("goals_for") FROM northern_league_stats_9 WHERE "lost" < 7 AND "position" = 2

Question: what is the position when the points 1 is less than 36, goals for is less than 40 and drawn is less than 9?
SQL: SELECT SUM("position") FROM northern_league_stats_9 WHERE "points_1" < 36 AND "goals_for" < 40 AND "drawn" < 9