CREATE TABLE table_name_28 (rank VARCHAR2, country VARCHAR2)

What was the rank for Great Britain?
SELECT COUNT(rank) FROM table_name_28 WHERE country = "great britain"
SELECT COUNT("rank") FROM "table_name_28" WHERE "country" = "great britain"