Task: Text to Code
Input (English): Step 1: For each row in Staff table, find the corresponding rows in Problems table.
Step 2: find product_id of the results of step 1 whose staff_last_name greater than or equals Medhurst and staff_last_name less than or equals Christop.
Step 3: find product_id of the results of step 1 whose staff_first_name equals Ashley.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T2.product_id FROM Staff AS T1 JOIN Problems AS T2 ON T1.staff_id = T2.closure_authorised_by_staff_id WHERE T1.staff_last_name > = "Christop" AND T1.staff_last_name < = "Medhurst" INTERSECT SELECT T2.product_id FROM Staff AS T1 JOIN Problems AS T2 ON T1.staff_id = T2.closure_authorised_by_staff_id WHERE T1.staff_first_name = "Ashley"