CREATE TABLE table_name_57 (school_club_team VARCHAR2, player VARCHAR2)

what is the school that hosts jim goodman
SELECT school_club_team FROM table_name_57 WHERE player = "jim goodman"
SELECT "school_club_team" FROM "table_name_57" WHERE "jim goodman" = "player"