user: ### NOW ANSWER:
Question: What is the average Touchdowns, when Yards is less than 293, and when Long is greater than 39?
Columns: ['Player', 'Attempts', 'Yards', 'Avg Yards', 'Long', 'Touchdowns']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Joe Horn', 94.0, 1340.0, 14.3, 52.0, 8.0]
SQL:

assistant: SELECT AVG("Touchdowns") FROM "Table" WHERE "Yards" < 293.0 AND "Long" > 39.0;