Which college have both players with position midfielder and players with position defender?
CREATE TABLE match_season (College VARCHAR, POSITION VARCHAR)
[SQL] SELECT College FROM match_season WHERE POSITION = "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION = "Defender" [/SQL]