CREATE TABLE table_name_47 (rank VARCHAR2, surname VARCHAR2)

What did the Surname Lindberg rank?
SELECT COUNT(rank) FROM table_name_47 WHERE surname = "lindberg"
SELECT COUNT("rank") FROM "table_name_47" WHERE "lindberg" = "surname"