CREATE TABLE table_name_70 (player VARCHAR2, school_club_team VARCHAR2)

What is the Player from Memphis?
SELECT player FROM table_name_70 WHERE school_club_team = "memphis"
SELECT "player" FROM "table_name_70" WHERE "memphis" = "school_club_team"