Find the first and last name of the staff members who reported problems from the product "rem" but not "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"
What about staff members who reported problems for the product "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"
What about staff members who reported problems for the product "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 = "aut"
What is the name of the staff member who reported problem id 1?
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 t1.problem_id = 1
What is the staff id of that person?
select t3.staff_id 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 t1.problem_id = 1