user: ### NOW ANSWER:
Question: How much Avg/G has a Loss larger than 117, and a Name of opponents, and a Gain smaller than 2444?
Columns: ['Name', 'GP-GS', 'Gain', 'Loss', 'Long', 'Avg/G']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Graig Cooper', '13-11', 888.0, 47.0, 51.0, 64.7]
SQL:

assistant: SELECT COUNT("Avg/G") FROM "Table" WHERE "Loss" > 117.0 AND "Name" = 'opponents' AND "Gain" < 2444.0;