select a.dept_no,b.dept_name,c.title,count(c.title)
from dept_emp a
inner join departments b on a.dept_no=b.dept_no
inner join titles c on c.emp_no=a.emp_no
group by a.dept_no,c.title
order by a.dept_no