CREATE TABLE table_name_97 (position VARCHAR2, player VARCHAR2)

What position did Max Redfield play?
SELECT position FROM table_name_97 WHERE player = "max redfield"
SELECT "position" FROM "table_name_97" WHERE "max redfield" = "player"