select dm.dept_no,dm.dept_name,t.title,count(t.title) count from dept_emp de join titles t on t.emp_no = de.emp_no and t.to_date = '9999-01-01' join departments dm on de.dept_no = dm.dept_no and de.to_date = '9999-01-01' group by dm.dept_no,t.title order by dm.dept_no;