CREATE TABLE match_season (College VARCHAR, POSITION VARCHAR)
SELECT College FROM match_season WHERE POSITION = "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION = "Defender"
วิทยาลัยไหนมีทั้งผู้เล่นตำแหน่งกองกลางและผู้เล่นตำแหน่งกองหลัง?
Which college have both players with position midfielder and players with position defender?