Table: huddersfield_1977_78_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 sum of league goals when the fa cup goals is more than 0?
SQL: SELECT SUM("league_goals") FROM huddersfield_1977_78_season WHERE "fa_cup_goals" > 0

Question: what is the average league cup goals when the league cup apps is 4, league goals is less than 4, fa cup apps is 1 and total apps is 35?
SQL: SELECT AVG("league_cup_goals") FROM huddersfield_1977_78_season WHERE "league_cup_apps" = 4 AND "league_goals" < 4 AND "fa_cup_apps" = '1' AND "total_apps" = '35'

Question: what is the average league cup goals when the position is df and total goals is more than 4?
SQL: SELECT AVG("league_cup_goals") FROM huddersfield_1977_78_season WHERE "position" = 'df' AND "total_goals" > 4

Question: what is the average fa cup goals when the fa cup apps is 0, total goals is less than 1 and position is df?
SQL: SELECT AVG("fa_cup_goals") FROM huddersfield_1977_78_season WHERE "fa_cup_apps" = '0' AND "total_goals" < 1 AND "position" = 'df'