select de.dept_no,dt.dept_name,t.title,count(t.title)
from dept_emp de left join departments dt on de.dept_no=dt.dept_no
left join titles t on de.emp_no = t.emp_no
where de.to_date="9999-01-01"
group by de.dept_no,t.title
order by de.dept_no