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

Question: what is the lowest league goals when the league apps is 1 and the fa cup goals is more than 0?
SQL: SELECT MIN("league_goals") FROM huddersfield_town_season WHERE "league_apps" = '1' AND "fa_cup_goals" > 0

Question: what is the highest fa cup goals when the total goals is more than 3 and total apps is 31 (1)?
SQL: SELECT MAX("fa_cup_goals") FROM huddersfield_town_season WHERE "total_goals" > 3 AND "total_apps" = '31 (1)'

Question: what is the league goals when the fa cup goals is higher than 0, the fa cup apps is 2 and the league apps is 45?
SQL: SELECT "league_goals" FROM huddersfield_town_season WHERE "fa_cup_goals" > 0 AND "fa_cup_apps" = '2' AND "league_apps" = '45'

Question: how many times is the total apps 1 and the fa cup goals less than 0 for bob mountain?
SQL: SELECT COUNT("total_goals") FROM huddersfield_town_season WHERE "total_apps" = '1' AND "name" = 'bob mountain' AND "fa_cup_goals" < 0