user: ### NOW ANSWER:
Question: What is the total of player Martin Randall, who has more than 1 League Cups and a league less than 18?
Columns: ['Player', 'Club', 'League', 'FA Cup', 'FA Trophy', 'League Cup', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Geoff Horsfield', 'Halifax Town', 30.0, 4.0, 0.0, 0.0, 34.0]
SQL:

assistant: SELECT "Total" FROM "Table" WHERE "League Cup" > 1.0 AND "League" < 18.0 AND "Player" = 'Martin Randall';