CREATE TABLE table_name_9 (captain VARCHAR2, team VARCHAR2)

Who captains Portsmouth?
SELECT captain FROM table_name_9 WHERE team = "portsmouth"
SELECT "captain" FROM "table_name_9" WHERE "portsmouth" = "team"