Task: Text to Code
Input (English): Find the names of schools that have some players in the mid position but not in the goalie position.
Output (English): SELECT cName FROM  tryout WHERE pPos  =  'mid' EXCEPT SELECT cName FROM  tryout WHERE pPos  =  'goalie'