Show all staff information.
select * from staff
What are the staff ids and genders of all staffs?
select staff_id, staff_gender from staff
What are the staff ids and genders of all staffs whose job title is Department Manager?
select t1.staff_id, t1.staff_gender from staff as t1 join staff_department_assignments as t2 on t1.staff_id = t2.staff_id where t2.job_title_code = "Department Manager"