Task: Text to Code
Input (English): Step 1: For each row in Staff table, find the corresponding rows in Problems table.
Step 2: find problem_id of the results of step 1 whose staff_first_name equals Lysanne and staff_last_name equals Turcotte
Output (English): SELECT T2.problem_id FROM Staff AS T1 JOIN Problems AS T2 ON T1.staff_id = T2.closure_authorised_by_staff_id WHERE T1.staff_first_name = "Lysanne" AND T1.staff_last_name = "Turcotte"