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"
college with both midfielder and defender refers to finding an intersection of colleges with players having 'Midfielder' and 'Defender' positions;