CREATE TABLE table_name_12 (class VARCHAR2, rank VARCHAR2)

Tell me the class with rank of 89th
SELECT class FROM table_name_12 WHERE rank = "89th"
SELECT "class" FROM "table_name_12" WHERE "89th" = "rank"