ใครเล่นให้กับ Memphis State?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Who played for Memphis State?It is not neccessary to use all the tables.
 table_name_47:  (player [ VARCHAR ] school_club_team [ VARCHAR) ]
SELECT player FROM table_name_47 WHERE school_club_team = "memphis state"