CREATE TABLE table_name_15 (position VARCHAR2, player VARCHAR2)

What position does John Carlson play?
SELECT position FROM table_name_15 WHERE player = "john carlson"
SELECT "position" FROM "table_name_15" WHERE "john carlson" = "player"