How many distinct colleges are associated with players from the team with name 'Columbus Crew'.
CREATE TABLE match_season (
    College VARCHAR,
    Team VARCHAR
)

CREATE TABLE team (
    Team_id VARCHAR,
    Name VARCHAR
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many distinct colleges are associated with players from the team with name 'Columbus Crew'. ### Input: CREATE TABLE match_season (
    College VARCHAR,
    Team VARCHAR
)

CREATE TABLE team (
    Team_id VARCHAR,
    Name VARCHAR
) ### Response: 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"