CREATE TABLE table_name_40 (bronze INT, rank INT)

What's the highest bronze with a less than 1 Rank?
SELECT MAX(bronze) FROM table_name_40 WHERE rank < 1
SELECT MAX("bronze") FROM "table_name_40" WHERE "rank" < 1