Hi there!  Can you provide me with a list of all Staff Department Assignments "date assigned to" values?
select date_assigned_to from staff_department_assignments
Thank you!  Now I realize that I should probably be asking for the date assigned from values... Therefore, can you provide me with a list of all staff IDs and their corresponding "date assigned from" values?
select staff_id, date_assigned_from from staff_department_assignments
Thank you for that!  Can you please filter this list to show only the row of the staff member who has the most recent date_assigned_from value?
select staff_id, date_assigned_from from staff_department_assignments order by date_assigned_from desc limit 1
Thank you!  Could you please display the name and job title of this staff person?
select staff_name,job_title_code from staff_department_assignments as t1 join staff as t2 on t1.staff_id = t2.staff_id where t1.staff_id = '1'