Table: player_name
Columns: name
league
fa_cup
league_cup
other
total

Question: What is the sum of Other, when the Name is Simon Gillett Category:Articles with hCards, and when the Total is less than 34?
SQL: SELECT SUM("other") FROM player_name WHERE "name" = 'simon gillett category:articles with hcards' AND "total" < 34

Question: What is the sum of the value "League Cup", when the Total is less than 1, and when the League is less than 0?
SQL: SELECT SUM("league_cup") FROM player_name WHERE "total" < 1 AND "league" < 0

Question: What is the greatest Total, when the FA Cup is 0, when the Name is Robbie Williams Category:Articles with hCards, and when the League Cup is less than 0?
SQL: SELECT MAX("total") FROM player_name WHERE "fa_cup" = 0 AND "name" = 'robbie williams category:articles with hcards' AND "league_cup" < 0

Question: What is the average Total, when the Name is Simon Gillett Category:Articles with hCards, and when the Other is greater than 3?
SQL: SELECT AVG("total") FROM player_name WHERE "name" = 'simon gillett category:articles with hcards' AND "other" > 3

Question: What is the sum of League Cup, when the Other is less than 1, when the Name is Gareth Farrelly Category:Articles with hCards, and when the League is greater than 1?
SQL: SELECT SUM("league_cup") FROM player_name WHERE "other" < 1 AND "name" = 'gareth farrelly category:articles with hcards' AND "league" > 1