user: ### NOW ANSWER:
Question: How many TDs for the player with a long of less than 4 and under 8 yards?
Columns: ['Player', 'Car.', 'Yards', 'Avg.', "TD's", 'Long']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Chris Robinson', 13.0, 58.0, 4.5, 3.0, 10.0]
SQL:

assistant: SELECT SUM("TD's") FROM "Table" WHERE "Long" < 4.0 AND "Yards" < 8.0;