CREATE TABLE team (team_id NUMBER, name CLOB)
CREATE TABLE country (country_id NUMBER, country_name CLOB, capital CLOB, official_native_language CLOB)
CREATE TABLE player (player_id NUMBER, player CLOB, years_played CLOB, total_wl CLOB, singles_wl CLOB, doubles_wl CLOB, team NUMBER)
CREATE TABLE match_season (season NUMBER, player CLOB, position CLOB, country NUMBER, team NUMBER, draft_pick_number NUMBER, draft_class CLOB, college CLOB)

How many distinct colleges are associated with players from the team with name 'Columbus Crew'.
SELECT COUNT(DISTINCT T1.college) FROM match_season AS T1 JOIN team AS T2 ON T1.team = T2.team_id WHERE T2.name = "Columbus Crew"
SELECT COUNT(DISTINCT "T1"."college") FROM "match_season" "T1" JOIN "team" "T2" ON "Columbus Crew" = "T2"."name" AND "T1"."team" = "T2"."team_id"