CREATE TABLE table_name_86 (rank VARCHAR2, name VARCHAR2)

What ranking is the Battersea Power Station?
SELECT rank FROM table_name_86 WHERE name = "battersea power station"
SELECT "rank" FROM "table_name_86" WHERE "battersea power station" = "name"