Task: Text to Code
Input (English): Step 1: For each row in Player table, find the corresponding rows in Tryout table.
Step 2: find the number of different cName in the results of step 1 whose pName equals mid and pPos equals goalie
Output (English): SELECT Count ( DISTINCT T2.cName ) FROM Player AS T1 JOIN Tryout AS T2 ON T1.pID = T2.pID WHERE T1.pName = "mid" AND T2.pPos = "goalie"