user: Question: 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?
Columns: ['Player', 'Rec.', 'Yards', 'Avg.', 'Long']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['DeSean Jackson', 62.0, 912.0, 14.7, 60.0]
SQL:

assistant: SELECT MAX("Yards") FROM "Table" WHERE "Rec." < 54.0 AND "Long" < 5.0 AND "Player" = 'todd herremans' AND "Avg." > 1.0;