多表连续连接加分组计数

select t.dept_no,t.dept_name,count(*) from departments as t join dept_emp as c on t.dept_no=c.dept_no join salaries as h on
c.emp_no=h.emp_no group by t.dept_no order by dept_no;