select  de.dept_no,ds.dept_name,ts.title,count(1) as count
from  dept_emp  de
join  departments ds  using(dept_no)
join titles ts  using(emp_no)
group by de.dept_no,ds.dept_name,ts.title
order by  dept_no asc,title asc