user: ### NOW ANSWER:
Question: What is the total number of appearances in the premier league when there were 10 appearances at UEFA and less than 4 at league cup?
Columns: ['Player', 'Position', 'Premier League', 'FA Cup', 'League Cup', 'UEFA Cup', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Michael Dawson', 'Defender', 37.0, 6.0, 4.0, 10.0, 57.0]
SQL:

assistant: SELECT COUNT("Premier League") FROM "Table" WHERE "UEFA Cup" = 10.0 AND "League Cup" < 4.0;