CREATE TABLE table_name_54 (player VARCHAR2, position VARCHAR2)

Who plays halfback?
SELECT player FROM table_name_54 WHERE position = "halfback"
SELECT "player" FROM "table_name_54" WHERE "halfback" = "position"