What is the average for the player with 1 TD, over 4 as a long, and under 1 carry?
CREATE TABLE table_54124 (
    "Player" text,
    "Car." real,
    "Yards" real,
    "Avg." real,
    "TD's" real,
    "Long" real
)
SELECT MIN("Avg.") FROM table_54124 WHERE "TD's" = '1' AND "Long" > '4' AND "Car." < '1'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average for the player with 1 TD, over 4 as a long, and under 1 carry? ### Input: CREATE TABLE table_54124 (
    "Player" text,
    "Car." real,
    "Yards" real,
    "Avg." real,
    "TD's" real,
    "Long" real
) ### Response: SELECT MIN("Avg.") FROM table_54124 WHERE "TD's" = '1' AND "Long" > '4' AND "Car." < '1'