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