Table: kenwyne_jones
Columns: name
premier_league
league_cup
fa_cup
total

Question: What is the lowest FA cup with 1 league cup, less than 12 total and 1 premier league?
SQL: SELECT MIN("fa_cup") FROM kenwyne_jones WHERE "league_cup" = 1 AND "total" < 12 AND "premier_league" = 1

Question: What is the highest league cup with more than 0 FA cups, a premier league less than 34 and a total of 11?
SQL: SELECT MAX("league_cup") FROM kenwyne_jones WHERE "fa_cup" > 0 AND "premier_league" < 34 AND "total" = 11

Question: What is the average total of kenwyne jones, who has more than 10 premier leagues?
SQL: SELECT AVG("total") FROM kenwyne_jones WHERE "name" = 'kenwyne jones' AND "premier_league" > 10

Question: What is the highest league cup of danny collins, who has more than 1 premier league?
SQL: SELECT MAX("league_cup") FROM kenwyne_jones WHERE "name" = 'danny collins' AND "premier_league" > 1