CREATE TABLE table_57992 ("Player" TEXT, "Car." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

How many yards for the player with over 0 TDs and an average of 2.9?
SELECT MIN("Yards") FROM table_57992 WHERE "TD's" > '0' AND "Avg." = '2.9'
SELECT MIN("Yards") FROM "table_57992" WHERE "Avg." = '2.9' AND "TD's" > '0'