CREATE TABLE table_40184 ("Rank" FLOAT, "Prev" FLOAT, "Player" CLOB, "Rating" FLOAT, "Chng" CLOB)

What is the highest prev that has 9 as the rank, with a rating less than 2746?
SELECT MAX("Prev") FROM table_40184 WHERE "Rank" = '9' AND "Rating" < '2746'
SELECT MAX("Prev") FROM "table_40184" WHERE "Rank" = '9' AND "Rating" < '2746'