Task: Text to Code
Input (English): Step 1: find the cName of Tryout table.
Step 2: find the pName, HS of Player table whose Player's pID one of the results of step 1
Output (English): SELECT T1.pName , T1.HS FROM Player AS T1 WHERE T1.pID IN ( SELECT T2.cName FROM Tryout AS T2 )