SELECT e.dept_no, dept_name, title, COUNT(*) AS count
FROM dept_emp e 
JOIN titles t ON e.emp_no=t.emp_no
JOIN departments d ON e.dept_no=d.dept_no
GROUP BY e.dept_no, t.title
ORDER BY e.dept_no