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

What is the average for the player with 1 TD, over 4 as a long, and under 1 carry?
SELECT MIN("Avg.") FROM table_54124 WHERE "TD's" = '1' AND "Long" > '4' AND "Car." < '1'
SELECT MIN("Avg.") FROM "table_54124" WHERE "Car." < '1' AND "Long" > '4' AND "TD's" = '1'