user: Question: What is the average total value in a League less than 1 with more than 1 League Cup?
Columns: ['Name', 'League', 'FA Cup', 'League Cup', 'Total']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Hamilton Ricard', 12.0, 0.0, 2.0, 14.0]
SQL:

assistant: SELECT AVG("Total") FROM "Table" WHERE "League" < 1.0 AND "League Cup" > 1.0;