select d.dept_no, dept_name, title, count(title) from titles t, dept_emp d, departments p where t.emp_no=d.emp_no and d.dept_no=p.dept_no group by 1, 3 order by 1
select d.dept_no, dept_name, title, count(title) from titles t, dept_emp d, departments p where t.emp_no=d.emp_no and d.dept_no=p.dept_no group by 1, 3 order by 1