CREATE TABLE table_5803 ("Player" TEXT, "Rec." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "Long" FLOAT)

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?
SELECT MAX("Yards") FROM table_5803 WHERE "Rec." < '54' AND "Long" < '5' AND "Player" = 'todd herremans' AND "Avg." > '1'
SELECT MAX("Yards") FROM "table_5803" WHERE "Avg." > '1' AND "Long" < '5' AND "Player" = 'todd herremans' AND "Rec." < '54'