Table schema:
CREATE TABLE table_name_47 (player VARCHAR, school_club_team VARCHAR)

Question: Who played for Memphis State?
SQL: SELECT player FROM table_name_47 WHERE school_club_team = "memphis state"