user: ### NOW ANSWER:
Question: Who is the player that has scored more than 0 league cup goals, but has than 13 total goals, and 4 league cup appearances total?
Columns: ['Name', 'Position', 'League Apps', 'League Goals', 'FA Cup Apps', 'FA Cup Goals', 'League Cup Apps', 'League Cup Goals', 'Total Apps', 'Total Goals']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real']
Sample row: ['Wayne Allison', 'FW', '44', 9.0, '4', 2.0, '3', 2.0, '51', 13.0]
SQL:

assistant: SELECT "Name" FROM "Table" WHERE "League Cup Goals" > 0.0 AND "Total Goals" < 13.0 AND "League Cup Apps" = '4';