Table: football_league_stats_4
Columns: scorer
club
league_goals
fa_cup_goals
league_cup_goals
total

Question: What is the sum of goals when the league cup goals are 4 and the FA cup goals are 0?
SQL: SELECT "total" FROM football_league_stats_4 WHERE "league_cup_goals" = '4' AND "fa_cup_goals" = '0'

Question: What is the amount of FA cups goals that were made when the total goals is greater than 16, and the league cup goals is 1 for the Norwich City club?
SQL: SELECT "fa_cup_goals" FROM football_league_stats_4 WHERE "total" > 16 AND "league_cup_goals" = '1' AND "club" = 'norwich city'

Question: What is the number of league goals when Bill Dearden was the scorer and there was 0 league cup goals?
SQL: SELECT "league_goals" FROM football_league_stats_4 WHERE "league_cup_goals" = '0' AND "scorer" = 'bill dearden'