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