CREATE TABLE table_10015132_9 (school_club_team VARCHAR2, player VARCHAR2)

What school/club team is Trey Johnson on?
SELECT school_club_team FROM table_10015132_9 WHERE player = "Trey Johnson"
SELECT "school_club_team" FROM "table_10015132_9" WHERE "Trey Johnson" = "player"