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
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