CREATE TABLE table_name_38 (school_club_team VARCHAR2, player VARCHAR2)

Roy Rogers play for what school/club team?
SELECT school_club_team FROM table_name_38 WHERE player = "roy rogers"
SELECT "school_club_team" FROM "table_name_38" WHERE "player" = "roy rogers"