Task: Text to Code
Input (English): Step 1: find the pName of Player table for which HS equals or between 1500 and 1200.
Step 2: find the pName of Player table for which HS greater than 500.
Step 3: show the rows that are in both the results of step 1 and the results of step 2
Output (English): SELECT pName FROM Player WHERE HS BETWEEN 1200 AND 1500 INTERSECT SELECT pName FROM Player WHERE HS > 500