What is the Job title code of department id 4?
select job_title_code from staff_department_assignments where department_id = 4
What is the date assigned from and of the staff id 1?
select date_assigned_from from staff_department_assignments where staff_id = 1
What is the department Id of sales person?
select distinct department_id from staff_department_assignments where job_title_code = "Sales Person"
What is the date assigned to clerical staff?
select date_assigned_to from staff_department_assignments where job_title_code = "Clerical Staff"
What is the date assigned from and date assigned to sales person?
select date_assigned_from,date_assigned_to from staff_department_assignments where job_title_code = "Sales Person"