select dm.dept_no,dm.dept_name,tl.title,count(*) from departments as dm join dept_emp as de on dm.dept_no = de.dept_no join titles as tl on tl.emp_no = de.emp_no group by dm.dept_no,dm.dept_name,tl.title order by de.dept_no asc,tl.title asc
