Task: Text to Code
Input (English): What are the names of all schools that have students trying out for the position of goal and 'mid'-field.
Output (English): SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid'