Which Yards is the highest one that has a Rec smaller than 54, and a Long smaller than 5, and a Player of todd herremans, and an Avg larger than 1?
CREATE TABLE table_name_51 (
    yards INTEGER,
    avg VARCHAR,
    player VARCHAR,
    rec VARCHAR,
    long VARCHAR
)
SELECT MAX(yards) FROM table_name_51 WHERE rec < 54 AND long < 5 AND player = "todd herremans" AND avg > 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: Which Yards is the highest one that has a Rec smaller than 54, and a Long smaller than 5, and a Player of todd herremans, and an Avg larger than 1? ### Input: CREATE TABLE table_name_51 (
    yards INTEGER,
    avg VARCHAR,
    player VARCHAR,
    rec VARCHAR,
    long VARCHAR
) ### Response: SELECT MAX(yards) FROM table_name_51 WHERE rec < 54 AND long < 5 AND player = "todd herremans" AND avg > 1