Show all the staff department assignments.
select * from staff_department_assignments
Which staff was assigned in 2016?
select * from staff_department_assignments where date_assigned_from like "2016%"
What are their names and genders?
select t1.staff_name, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.date_assigned_from like "2016%"