CREATE TABLE table_54122 ("Player" CLOB, "Car." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

What was the longest carry for kevin clemens with under 31 yards total?
SELECT MAX("Long") FROM table_54122 WHERE "Player" = 'kevin clemens' AND "Yards" < '31'
SELECT MAX("Long") FROM "table_54122" WHERE "Player" = 'kevin clemens' AND "Yards" < '31'