CREATE TABLE table_name_2 (rank VARCHAR, bronze VARCHAR, gold VARCHAR)

What is the rank of the team with 1 bronze and 0 gold medals?
SELECT rank FROM table_name_2 WHERE bronze = 1 AND gold = 0
SELECT "rank" FROM "table_name_2" WHERE "bronze" = 1 AND "gold" = 0