Table: player_stats_15
Columns: position
nationality
name
league_apps
league_goals
fa_cup_apps
fa_cup_goals
total_apps
total_goals

Question: How many league apps did the player with 11 team goals have?
SQL: SELECT "league_apps" FROM player_stats_15 WHERE "total_goals" = 11

Question: What is the lowest number of total goals for a player with 6 league goals?
SQL: SELECT MIN("total_goals") FROM player_stats_15 WHERE "league_goals" = 6

Question: What is the lowest number of fa cup goals by a player?
SQL: SELECT MIN("fa_cup_goals") FROM player_stats_15