CREATE TABLE table_name_10 (name VARCHAR2, rank VARCHAR2)

Can you tell me the Name that has the Rank of 4?
SELECT name FROM table_name_10 WHERE rank = 4
SELECT "name" FROM "table_name_10" WHERE "rank" = 4