上代码：

select de.dept_no, d.dept_name, t.title, count(t.title)
from departments d join dept_emp de on d.dept_no = de.dept_no
     join titles t on t.emp_no = de.emp_no
group by de.dept_no, t.title
order by de.dept_no, t.title