huangjiewen4
12/29/2018 - 8:28 AM

avg sql

for each employee in the employees table, the average salary of the employees reporting to the same manager who were hired in the range just before through just after the employee:

sql
content_copyfile_download
SELECT manager_id, last_name, hire_date, salary,
       AVG(salary) OVER (PARTITION BY manager_id ORDER BY hire_date 
  ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS c_mavg
  FROM employees
  ORDER BY manager_id, hire_date, salary;