CREATE TABLE match_season (College VARCHAR(255), POSITION VARCHAR(255))
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"