CREATE TABLE table_2305948_1 (country VARCHAR2, name VARCHAR2)

What countries does the Rock come from?
SELECT COUNT(country) FROM table_2305948_1 WHERE name = "The Rock"
SELECT COUNT("country") FROM "table_2305948_1" WHERE "The Rock" = "name"