CREATE TABLE table_10402018_1 (london VARCHAR2, character VARCHAR2)

How many people play Frank in London?
SELECT COUNT(london) FROM table_10402018_1 WHERE character = "Frank"
SELECT COUNT("london") FROM "table_10402018_1" WHERE "Frank" = "character"