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

Question: Which FA Cup Apps have League Apps of 21?
SQL: SELECT "fa_cup_apps" FROM huddersfield_player_stats WHERE "league_apps" = '21'

Question: Which Name has a League Cup Goals of 0, and League Apps of 1?
SQL: SELECT "name" FROM huddersfield_player_stats WHERE "league_cup_goals" = 0 AND "league_apps" = '1'

Question: Which Total Goals have a League Cup Goals larger than 0, and FA Cup Goals larger than 0?
SQL: SELECT AVG("total_goals") FROM huddersfield_player_stats WHERE "league_cup_goals" > 0 AND "fa_cup_goals" > 0

Question: Which Total Goals have Total Apps of 42 (3), and League Goals smaller than 1?
SQL: SELECT MAX("total_goals") FROM huddersfield_player_stats WHERE "total_apps" = '42 (3)' AND "league_goals" < 1