12.查询开发部员工的工资总和.sql

来自「介绍了一些数据库中常用的语句」· SQL 代码 · 共 5 行

select sum(employees.salary) as 工资和,departments.depname as 部门
from departments INNER JOIN 
    employees on  departments.depid= employees.department
where (departments.depname='开发部')
group by departments.depname