CREATE TABLE table_name_38 (earnings__ NUMBER, rank NUMBER)

Who has the lowest earnings that has a rank smaller than 2?
SELECT MIN(earnings__) AS $__ FROM table_name_38 WHERE rank < 2
SELECT MIN("earnings__") AS "$__" FROM "table_name_38" WHERE "rank" < 2