Table: footballer_stats
Columns: season
division
league_apps_sub
league_goals
fa_cup_apps_sub
fa_cup_goals
fl_cup_apps_sub
fl_cup_goals
other_apps
other_goals
total_apps_sub
total_goals

Question: League apps (sub) maximum?
SQL: SELECT MAX("league_apps_sub") FROM footballer_stats

Question: When total goals is 11 what was the league apps (sub)?
SQL: SELECT MAX("league_apps_sub") FROM footballer_stats WHERE "total_goals" = 11