CREATE TABLE table_name_47 (total INT, rank INT)

Which Total is the lowest one that has a Rank smaller than 1?
SELECT MIN(total) FROM table_name_47 WHERE rank < 1
SELECT MIN("total") FROM "table_name_47" WHERE "rank" < 1