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"
colleges with players of position midfielder and defender refers to using INTERSECT between two SELECT queries filtering by POSITION = 'Midfielder' and POSITION = 'Defender';