CREATE TABLE table_name_22 (rank NUMBER, time VARCHAR2)

Who placed highest with a time of 1:47.70?
SELECT MIN(rank) FROM table_name_22 WHERE time = "1:47.70"
SELECT MIN("rank") FROM "table_name_22" WHERE "1:47.70" = "time"