CREATE TABLE table_name_94 (opponent VARCHAR2, rank VARCHAR2)

What is the Opponent that has a Rank of 4?
SELECT opponent FROM table_name_94 WHERE rank = "4"
SELECT "opponent" FROM "table_name_94" WHERE "4" = "rank"