What are first and last names of all the staff members?
select staff_first_name, staff_last_name from staff
Which ones reported on problems with products named "rem" or "aut"?
select t3.staff_first_name, t3.staff_last_name from problems as t1 join product as t2 join staff as t3 on t1.product_id = t2.product_id and t1.reported_by_staff_id = t3.staff_id where t2.product_name = "rem" or t2.product_name = "aut"
Of these, who reported on "rem"?
select t3.staff_first_name, t3.staff_last_name from problems as t1 join product as t2 join staff as t3 on t1.product_id = t2.product_id and t1.reported_by_staff_id = t3.staff_id where t2.product_name = "rem"
Of these, who did not report on "aut"
select t3.staff_first_name, t3.staff_last_name from problems as t1 join product as t2 join staff as t3 on t1.product_id = t2.product_id and t1.reported_by_staff_id = t3.staff_id where t2.product_name = "rem" except select t3.staff_first_name, t3.staff_last_name from problems as t1 join product as t2 join staff as t3 on t1.product_id = t2.product_id and t1.reported_by_staff_id = t3.staff_id where t2.product_name = "aut"