Table: player_stats
Columns: season
division
league_apps
league_goals
fa_cup_apps
fa_cup_goals
total_apps
total_goals

Question: What is the highest value of Total Goals?
SQL: SELECT MAX("total_goals") FROM player_stats

Question: When FA Cup Apps is 9 what is the smallest number of FA Cup Goals?
SQL: SELECT MIN("fa_cup_goals") FROM player_stats WHERE "fa_cup_apps" = 9

Question: What is the smallest number of Total Goals?
SQL: SELECT MIN("total_goals") FROM player_stats