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


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