What are all the products reported by staff named Jolie Weber?
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 = "Jolie" and t2.staff_last_name = "Weber"
How about Dameon Fami?
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 = "Dameon" and t2.staff_last_name = "Fami"
Which products are reported by either one?
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 = "Dameon" and t2.staff_last_name = "Frami"
What are their 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 = "Dameon" and t2.staff_last_name = "Frami" union 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 = "Jolie" and t2.staff_last_name = "Weber"