Show all the staff.
select * from staff
Sort all the staff by their assigned date in a descending manner.
select * from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id order by t2.date_assigned_to desc limit 1
What is the name and job title of the staff who was assigned the latest?
select t1.staff_name, t2.job_title_code from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id order by t2.date_assigned_to desc limit 1