CREATE TABLE table_name_50 (player VARCHAR, position VARCHAR)

Which player is a centre?
SELECT player FROM table_name_50 WHERE position = "centre"
SELECT "player" FROM "table_name_50" WHERE "centre" = "position"