Table: huddersfield_87_88_player
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 apps when the total goals is less than 2 and the total apps is 12?
SQL: SELECT "league_cup_apps" FROM huddersfield_87_88_player WHERE "total_goals" < 2 AND "total_apps" = '12'

Question: what is the average ga cup goals when the league cup apps is 2, the fa cup apps is 3 and the league goals is 3?
SQL: SELECT AVG("fa_cup_goals") FROM huddersfield_87_88_player WHERE "league_cup_apps" = '2' AND "fa_cup_apps" = '3' AND "league_goals" = 3

Question: what is the highest fa cup goals when flt goals is more than 0?
SQL: SELECT MAX("fa_cup_goals") FROM huddersfield_87_88_player WHERE "flt_goals" > 0

Question: what is the total apps when the league apps is 4 (2)?
SQL: SELECT "total_apps" FROM huddersfield_87_88_player WHERE "league_apps" = '4 (2)'