SELECT product_id FROM problems AS T1 JOIN staff AS T2 ON T1.reported_by_staff_id = T2.staff_id WHERE T2.staff_first_name = "Christop" AND T2.staff_last_name = "Berge" INTERSECT SELECT product_id FROM problems AS T1 JOIN staff AS T2 ON T1.closure_authorised_by_staff_id = T2.staff_id WHERE T2.staff_first_name = "Ashley" AND T2.staff_last_name = "Medhurst"
For which product was there a problem reported by Christop Berge, with closure authorised by Ashley Medhurst? Return the product ids.
SELECT product_id FROM problems AS T1 JOIN staff AS T2 ON T1.reported_by_staff_id = T2.staff_id WHERE T2.staff_first_name = `` Christop '' AND T2.staff_last_name = `` Berge '' INTERSECT SELECT product_id FROM problems AS T1 JOIN staff AS T2 ON T1.closure_authorised_by_staff_id = T2.staff_id WHERE T2.staff_first_name = `` Ashley '' AND T2.staff_last_name = `` Medhurst ''
select product_id from problems as t1 join staff as t2 on t1 . reported_by_staff_id = t2 . staff_id where t2 . staff_first_name = value and t2 . staff_last_name = value intersect select product_id from problems as t1 join staff as t2 on t1 . closure_authorised_by_staff_id = t2 . staff_id where t2 . staff_first_name = value and t2 . staff_last_name = value
For which product was there a problem reported by Christop Berge , with closure authorised by Ashley Medhurst ? Return the product ids .