user: ### NOW ANSWER:
Question: What is the championship of Jem Karacan that has a total of 2 and a league cup more than 0?
Columns: ['Name', 'Championship', 'FA Cup', 'League Cup', 'Total']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Kevin Doyle', 18.0, 0.0, 0.0, 18.0]
SQL:

assistant: SELECT "Championship" FROM "Table" WHERE "Total" = 2.0 AND "League Cup" > 0.0 AND "Name" = 'Jem Karacan';