Table: player_stats_89
Columns: name
nation
position
league_apps
league_goals
fa_cup_apps
fa_cup_goals
league_cup_apps
league_cup_goals
flt_apps
flt_goals
total_apps
total_goals

Question: Which League Cup Goals have a League Cup Apps of 1 (1)?
SQL: SELECT "league_cup_goals" FROM player_stats_89 WHERE "league_cup_apps" = '1 (1)'

Question: Which FA Cup Apps have Total Goals larger than 6, and an FA Cup Goals smaller than 1?
SQL: SELECT "fa_cup_apps" FROM player_stats_89 WHERE "total_goals" > 6 AND "fa_cup_goals" < 1

Question: How many League Goals have an FA Cup Apps of 0 (1)?
SQL: SELECT COUNT("league_goals") FROM player_stats_89 WHERE "fa_cup_apps" = '0 (1)'