select d1.dept_no,d1.dept_name,c.title,count(title) count from (select a.dept_no, dept_name, emp_no from departments a join dept_emp b on a.dept_no=b.dept_no) d1 join titles c on d1.emp_no=c.emp_no group by d1.dept_no,d1.dept_name,c.title order by dept_no,title 查询结果:部门编号,部门名称,员工称号,员工称号的计数查询来源:depart...