CREATE TABLE table_name_43 (name VARCHAR2, pos VARCHAR2)

What's the name of the person in the CF Pos?
SELECT name FROM table_name_43 WHERE pos = "cf"
SELECT "name" FROM "table_name_43" WHERE "cf" = "pos"