Table: football_season_stats_5
Columns: squad_no
name
position
league_apps
league_goals
fa_cup_apps
fa_cup_goals
league_cup_apps
league_cup_goals
total_apps
total_goals

Question: What is the most league cup goals for David Beresford having less than 0 FA Cup Goals?
SQL: SELECT MAX("league_cup_goals") FROM football_season_stats_5 WHERE "name" = 'david beresford' AND "fa_cup_goals" < 0

Question: What is the league goals when the league cup goals is less than 0 and 16 (1) league apps?
SQL: SELECT AVG("league_goals") FROM football_season_stats_5 WHERE "league_apps" = '16 (1)' AND "league_cup_goals" < 0

Question: What is the league cup apps when the league goals are greater than 3, there are 30 (2) total apps, and has a position of mf?
SQL: SELECT "league_cup_apps" FROM football_season_stats_5 WHERE "position" = 'mf' AND "league_goals" > 3 AND "total_apps" = '30 (2)'

Question: What is the FA Cup App for Squad Number 3 having fewer than 4 league goals?
SQL: SELECT "fa_cup_apps" FROM football_season_stats_5 WHERE "league_goals" < 4 AND "squad_no" = 3