Table: huddersfield_2007_08_players
Columns: squad_no
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: Tell me the highest league goals with total goals less than 1 and FA cups more than 0
SQL: SELECT MAX("league_goals") FROM huddersfield_2007_08_players WHERE "total_goals" < 1 AND "fa_cup_goals" > 0

Question: I want to know the sum of fa cup goals for david mirfin and total goals less than 1
SQL: SELECT SUM("fa_cup_goals") FROM huddersfield_2007_08_players WHERE "name" = 'david mirfin' AND "total_goals" < 1

Question: Tell me the league apps with league goals less than 2 and position of df and FA cup apps of 5
SQL: SELECT "league_apps" FROM huddersfield_2007_08_players WHERE "league_goals" < 2 AND "position" = 'df' AND "fa_cup_apps" = '5'