user: Question: What is the total number of long dubose, e., who had 0 losses, a gain less than 17, and an avg/g bigger than 0, had?
Columns: ['Name', 'Gain', 'Loss', 'Long', 'Avg/G']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Wiliams, E.', 690.0, 19.0, 46.0, 55.9]
SQL:

assistant: SELECT COUNT("Long") FROM "Table" WHERE "Loss" = 0.0 AND "Gain" < 17.0 AND "Avg/G" > 0.0 AND "Name" = 'dubose, e.';