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 striker.
Step 3: For each row in Player table, find the corresponding rows in Tryout table.
Step 4: find pName of the results of step 3 whose pPos equals yes.
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 = "striker" INTERSECT SELECT T3.pName FROM Player AS T3 JOIN Tryout AS T2 ON T3.pID = T2.pID WHERE T2.pPos = "yes"