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