Listing 2: Query That Finds the Total and Average Salaries 

SELECT dept_id, job,
 SUM(salary) OVER(PARTITION BY job) AS sum_sal_job,
 AVG(salary) OVER(PARTITION BY dept_id) AS avg_sal_dept
 FROM employee;