26.汇总各个部门当前员工的title类型的分配数目
题目内容:
代码及思路:
首先整理题目中重要信息:1.各部门;2.所有员工的titiles及个数.
SELECT de.dept_no,dp.dept_name,titles.title,COUNT(titles.title) AS count
FROM titles INNER JOIN dept_emp AS de ON titles.emp_no=de.emp_no AND titles.to_date='9999-01-01' AND de.to_date='9999-01-01'
INNER JOIN departments AS dp ON de.dept_no=dp.dept_no
GROUP BY de.dept_no,titles.title;