CREATE TABLE table_48389 ("Player" TEXT, "Attempts" FLOAT, "Yards" FLOAT, "Avg Yards" FLOAT, "Long" FLOAT, "Touchdowns" FLOAT)

What is the average Touchdowns, when Yards is less than 293, and when Long is greater than 39?
SELECT AVG("Touchdowns") FROM table_48389 WHERE "Yards" < '293' AND "Long" > '39'
SELECT AVG("Touchdowns") FROM "table_48389" WHERE "Long" > '39' AND "Yards" < '293'