CREATE TABLE table_64480 ("Rank" FLOAT, "Name" CLOB, "1st run" CLOB, "2nd run" CLOB, "3rd run" CLOB, "Total" FLOAT)

Which Rank has a Total smaller than 10, and a 3rd run of 36.457 (2)?
SELECT MAX("Rank") FROM table_64480 WHERE "Total" < '10' AND "3rd run" = '36.457 (2)'
SELECT MAX("Rank") FROM "table_64480" WHERE "3rd run" = '36.457 (2)' AND "Total" < '10'