Table: kevin_doyle
Columns: name
championship
fa_cup
league_cup
total

Question: What is the total championships that the league cup is less than 0?
SQL: SELECT SUM("championship") FROM kevin_doyle WHERE "league_cup" < 0

Question: What is the total championships of James Henry that has a league cup more than 1?
SQL: SELECT SUM("championship") FROM kevin_doyle WHERE "league_cup" > 1 AND "name" = 'james henry'

Question: What is the championship of Jem Karacan that has a total of 2 and a league cup more than 0?
SQL: SELECT "championship" FROM kevin_doyle WHERE "total" = 2 AND "league_cup" > 0 AND "name" = 'jem karacan'