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

Question: How many Total Goals values have 0 League Cup Goals?
SQL: SELECT COUNT("total_goals") FROM huddersfield_player_stats_2 WHERE "league_cup_goals" < 0

Question: What is the smallest number of FA Cup Goals for players with 4 FA Cup Appearances, 49 Total Appearances, and more than 17 total goals?
SQL: SELECT MIN("fa_cup_goals") FROM huddersfield_player_stats_2 WHERE "fa_cup_apps" = '4' AND "total_apps" = '49' AND "total_goals" > 17

Question: What is the average number of League Goals for palyers with 0 FA Cup Goals?
SQL: SELECT AVG("league_goals") FROM huddersfield_player_stats_2 WHERE "fa_cup_goals" < 0