原题链接
1.三表连接再筛选条件
select d.dept_no,d.dept_name,count(s.salary)as sum
from departments as d,dept_emp as d2,salaries as s
where d.dept_no=d2.dept_no
and s.emp_no=d2.emp_no
group by d.dept_no,d.dept_name
order by d2.dept_no asc;
sunm和count函数区别:
Sum(列) 是求和,把所有列的值进行汇总求和;
COUNT(列) 是行数汇总,只要列的值不为Null,就会增加1;