SCHEMA:
CREATE TABLE table_name_7 (touchdowns INTEGER, yards VARCHAR, long VARCHAR)
USER:
What is the average Touchdowns, when Yards is less than 293, and when Long is greater than 39?

QUERY:
SELECT AVG(touchdowns) FROM table_name_7 WHERE yards < 293 AND long > 39