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

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