Yes, please
select distinct college from match_season
Thank you. And what are the names of the players who play for those schools?
select player from match_season
Thank you. Which players play midfielder?
select player from match_season where position = 'Midfielder'
Which college have both players with position midfielder and players with position defender?
select college from match_season where position = "Midfielder" intersect select college from match_season where position = "Defender"