Task: Text to Code
Input (English): Step 1: For each row in Player table, find the corresponding rows in Tryout table.
Step 2: find pName, pPos of the results of step 1 whose HS less than 1500
Output (English): SELECT T1.pName , T2.pPos FROM Player AS T1 JOIN Tryout AS T2 ON T1.pID = T2.pID WHERE T1.HS < 1500