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 WHERE Rec. < 54 AND Long < 5 AND Player = todd herremans AND Avg. > 1