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

Question: What is the average goals against when there are more than 42 played?
SQL: SELECT AVG("goals_against") FROM northern_league_stats_16 WHERE "played" > 42

Question: What is the goal difference for the team from Chorley?
SQL: SELECT "goal_difference" FROM northern_league_stats_16 WHERE "team" = 'chorley'