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

Question: Who had fa cup goals of 0, league cup goals less than 2, and total goals of 2?
SQL: SELECT "name" FROM huddersfield_player_stats_3 WHERE "fa_cup_goals" = 0 AND "league_cup_goals" < 2 AND "total_goals" = 2

Question: what is the fa cup goals when total apps is 10 (4)?
SQL: SELECT SUM("fa_cup_goals") FROM huddersfield_player_stats_3 WHERE "total_apps" = '10 (4)'

Question: how many times is the fa cup apps more than 0, the position mf and the league goals 4?
SQL: SELECT COUNT("total_goals") FROM huddersfield_player_stats_3 WHERE "fa_cup_apps" > 0 AND "position" = 'mf' AND "league_goals" = 4