题解 | #汇总各个部门当前员工的title类型的分配数目#
汇总各个部门当前员工的title类型的分配数目
http://www.nowcoder.com/practice/4bcb6a7d3e39423291d2f7bdbbff87f8
select distinct departments.*,titles.title,count(titles.title) over (partition by departments.dept_no , titles.title)
from departments left join dept_emp on dept_emp.dept_no=departments.dept_no
left join titles on titles.emp_no=dept_emp.emp_no
order by departments.dept_no,titles.title
from departments left join dept_emp on dept_emp.dept_no=departments.dept_no
left join titles on titles.emp_no=dept_emp.emp_no
order by departments.dept_no,titles.title