CREATE TABLE table_name_15 (school_club_team VARCHAR, player VARCHAR)

Who does jeremy evans play for?
SELECT school_club_team FROM table_name_15 WHERE player = "jeremy evans"
SELECT "school_club_team" FROM "table_name_15" WHERE "jeremy evans" = "player"