Who played for Memphis State?
CREATE TABLE table_name_47 (player VARCHAR, school_club_team VARCHAR)
SELECT player FROM table_name_47 WHERE school_club_team = "memphis state"
### Context: CREATE TABLE table_name_47 (player VARCHAR, school_club_team VARCHAR) ### Question: Who played for Memphis State? ### Answer: SELECT player FROM table_name_47 WHERE school_club_team = "memphis state"