SUM

SELECT
  dept_no,
  SUM (salary),
FROM employee
GROUP BY dept_no