Listing 1: Query That Finds the Total Salary for Each Department

SELECT dept_id, last_name AS name,
 SUM(salary) OVER(PARTITION BY dept_id) AS sum_sal_dept
 FROM employee;