user: ### NOW ANSWER:
Question: What was the average for the player that scored 116 yards and had TD's less than 1?
Columns: ['Player', 'Rec.', 'Yards', 'Avg.', "TD's", 'Long']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Lawrence Samuels', 11.0, 116.0, 10.5, 1.0, 18.0]
SQL:

assistant: SELECT COUNT("Avg.") FROM "Table" WHERE "Yards" = 116.0 AND "TD's" < 1.0;