user: ### NOW ANSWER:
Question: Who is the player who has a total less than 4, no scottish cups, and a league cup greater than 0?
Columns: ['Player', 'Position', 'League Cup', 'Scottish Cup', 'UEFA Champions League', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Scott McDonald', 'Forward', 1.0, 1.0, 1.0, 19.0]
SQL:

assistant: SELECT "Player" FROM "Table" WHERE "Total" < 4.0 AND "Scottish Cup" = 0.0 AND "League Cup" > 0.0;