Database: match_season
Question: Which college have both players with position midfielder and players with position defender?
SQL:
SELECT College FROM match_season WHERE POSITION  =  "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION  =  "Defender"