CREATE TABLE table_name_59 (name VARCHAR2, rank VARCHAR2, nationality VARCHAR2)

What's the name of spain rank greater than 2?
SELECT name FROM table_name_59 WHERE rank > 2 AND nationality = "spain"
SELECT "name" FROM "table_name_59" WHERE "nationality" = "spain" AND "rank" > 2