Find the names of schools that have some players in the mid position but not in the goalie position.
CREATE TABLE tryout (cName VARCHAR, pPos VARCHAR)
SELECT cName FROM tryout WHERE pPos = 'mid' EXCEPT SELECT cName FROM tryout WHERE pPos = 'goalie'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE tryout (cName VARCHAR, pPos VARCHAR) Question: Find the names of schools that have some players in the mid position but not in the goalie position. [/INST] SELECT cName FROM tryout WHERE pPos = 'mid' EXCEPT SELECT cName FROM tryout WHERE pPos = 'goalie' </s>