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