user: ### NOW ANSWER:
Question: How many FA Trophy has a Total larger than 17 and a Player of david gamble and a League Cup larger than 0?
Columns: ['Player', 'Club', 'League', 'FA Cup', 'FA Trophy', 'League Cup', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Paul Dobson', 'Gateshead', 25.0, 3.0, 4.0, 2.0, 34.0]
SQL:

assistant: SELECT COUNT("FA Trophy") FROM "Table" WHERE "Total" > 17.0 AND "Player" = 'david gamble' AND "League Cup" > 0.0;