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