Table: huddersfield_player_stats
Columns: name
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: What is the league cup app with league cup goals more than 0?
SQL: SELECT "league_cup_apps" FROM huddersfield_player_stats WHERE "league_cup_goals" > 0

Question: What is the fa cup apps with 0 league cup goals, and a total of 43 apps?
SQL: SELECT "fa_cup_apps" FROM huddersfield_player_stats WHERE "league_cup_goals" = 0 AND "total_apps" = '43'

Question: What is the highest FLT goals with 0 league cup goals, a GK position, and 2 league cup apps?
SQL: SELECT MAX("flt_goals") FROM huddersfield_player_stats WHERE "league_cup_goals" = 0 AND "position" = 'gk' AND "league_cup_apps" = '2'