题目
解答
刚开始写的代码缺少group by行代码,通不过测试,看讨论可知:
需要将dept_no作为分组条件才行, 因为不同部门,包含了不同title,首先是根据部门分组,然后同一部分再根据title分组。
select d.dept_no,d.dept_name,t.title,count(t.title) as "count"
from titles as t join dept_emp as de on t.emp_no=de.emp_no
join departments as d on de.dept_no=d.dept_no
where de.to_date = '9999-01-01'
and t.to_date = '9999-01-01'
group by d.dept_no,t.title
order by d.dept_no;