user: ### NOW ANSWER:
Question: What is the total gain for brandon mcrae with a loss less than 4, and an Avg/g less than -0.1?
Columns: ['Name', 'GP-GS', 'Gain', 'Loss', 'Long', 'Avg/G']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Anthony Dixon', '12-12', 930.0, 61.0, 71.0, 72.4]
SQL:

assistant: SELECT COUNT("Gain") FROM "Table" WHERE "Long" < 4.0 AND "Name" = 'brandon mcrae' AND "Avg/G" < -0.1;