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
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
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 value
What is the name and job title of the staff who was assigned the latest ?