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

Question: What average drawn has a played greater than 42?
SQL: SELECT AVG("drawn") FROM northern_league_stats_10 WHERE "played" > 42

Question: What is the highest played that has a position less than 17, and 63 as the goals for?
SQL: SELECT MAX("played") FROM northern_league_stats_10 WHERE "position" < 17 AND "goals_for" = 63

Question: What is the lowest played that has a position greater than 6, 61 as the goals against, with a loss less than 16?
SQL: SELECT MIN("played") FROM northern_league_stats_10 WHERE "position" > 6 AND "goals_against" = 61 AND "lost" < 16

Question: What is the highest goals for that has a drawn less than 11, with a played less than 42?
SQL: SELECT MAX("goals_for") FROM northern_league_stats_10 WHERE "drawn" < 11 AND "played" < 42

Question: What is the average goals for that has +40 as the goals difference, with points 1 greater than 55?
SQL: SELECT AVG("goals_for") FROM northern_league_stats_10 WHERE "goal_difference" = '+40' AND "points_1" > 55