CREATE TABLE table_name_24 (total INT, rank VARCHAR, gold VARCHAR, bronze VARCHAR)

What is the highest metal total when there are 2 Gold medals, 0 Bronze metals, and the rank is smaller than 2?
SELECT MAX(total) FROM table_name_24 WHERE gold = 2 AND bronze = 0 AND rank < 2
SELECT MAX("total") FROM "table_name_24" WHERE "bronze" = 0 AND "gold" = 2 AND "rank" < 2