select d.dept_no, d.dept_name,count(s.salary) as sum from departments as d inner join dept_emp as de on d.dept_no =de.dept_no inner join salaries as s on s.emp_no = de.emp_no group by d.dept_no order by d.dept_no asc; 这个SQL查询的目标是从三个表中提取信息:departments、dept_emp 和 salaries,并计算每个部门中员工的薪水记录总数。以下是...