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

How many TDs for the player averaging over 7, and over 39 yards?
SELECT MIN("TD's") FROM table_57993 WHERE "Avg." > '7' AND "Yards" > '39'
SELECT MIN("TD's") FROM "table_57993" WHERE "Avg." > '7' AND "Yards" > '39'