CREATE TABLE table_name_86 (player VARCHAR2, school_club_team VARCHAR2)

Who is the player from Auburn?
SELECT player FROM table_name_86 WHERE school_club_team = "auburn"
SELECT "player" FROM "table_name_86" WHERE "auburn" = "school_club_team"