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

Question: How many league goals did the player with 10 league apps and 0 FA cup goals have?
SQL: SELECT COUNT("league_goals") FROM huddersfield_1980_81_player WHERE "fa_cup_goals" = 0 AND "league_apps" = '10'

Question: What was the sum of league goals where the toal was 8 and league cup goals were larger than 0?
SQL: SELECT SUM("league_goals") FROM huddersfield_1980_81_player WHERE "total_goals" = 8 AND "league_cup_goals" > 0