how many departments are there
select count ( distinct department_id ) from staff_department_assignments
what is the jobe title code of department id 5
select job_title_code from staff_department_assignments where department_id = 5
how many persons in department manger
select count ( * ) from staff_department_assignments where job_title_code = "Department Manager"