CREATE TABLE table_name_44 (athletes VARCHAR2, rank VARCHAR2)

Which Athletes have a Rank of bronze?
SELECT athletes FROM table_name_44 WHERE rank = "bronze"
SELECT "athletes" FROM "table_name_44" WHERE "bronze" = "rank"