List the college and the corresponding team name.
select college,name from match_season as t1 join team as t2 on t1.team = t2.team_id
How many unique colleges are there for team 'Miami Fusion'?
select count(distinct college) from match_season as t1 join team as t2 on t1.team = t2.team_id where t2.name = 'Miami Fusion'
What about the team "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"