CREATE TABLE table_name_57 (player VARCHAR2, position VARCHAR2)

What player is a cornerback?
SELECT player FROM table_name_57 WHERE position = "cornerback"
SELECT "player" FROM "table_name_57" WHERE "cornerback" = "position"