select dept_no,dept_name,title,count(1)
from titles left join dept_emp using(emp_no) left join departments using(dept_no)
group by dept_no,title
order by dept_no,title