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