What are the staff names with job title code Sales Person?
select t1.staff_name from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Sales Person"
Yes.
select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Sales Person" except select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Clerical Staff"
What are the staff names and genders for people with job title code Sales Person?
select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Sales Person"
How about with job title code Clerical Staff?
select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Clerical Staff"
Which of the people with job title code Sales Person are not Clerical Staff?
select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Sales Person" except select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Clerical Staff"