what is the date assigned to of the department managers?
select date_assigned_to from staff_department_assignments where job_title_code = 'Department Manager'
list the name of staff who has been assigned multiple jobs?
select t1.staff_name from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id group by t2.staff_id having count ( * ) > 1
what is the date assigned from sales person?
select date_assigned_from from staff_department_assignments where job_title_code = 'Sales Person'