Task: Text to Code
Input (English): Step 1: find the cName of Tryout table for which pPos equals mid.
Step 2: For each row in Player table, find the corresponding rows in Tryout table.
Step 3: find cName of the results of step 2 whose HS equals 1200.
Step 4: show the rows that are in both the results of step 1 and the results of step 3
Output (English): SELECT T1.cName FROM Tryout AS T1 WHERE T1.pPos = "mid" INTERSECT SELECT T1.cName FROM Player AS T2 JOIN Tryout AS T1 ON T2.pID = T1.pID WHERE T2.HS = 1200