Which college have both players with position midfielder and players with position defender?
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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE match_season (College VARCHAR, POSITION VARCHAR) Question: Which college have both players with position midfielder and players with position defender? [/INST] SELECT College FROM match_season WHERE POSITION = "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION = "Defender" </s>