easy5 pts · first answer countswindow-functionssql

Salary vs department average

Which query shows each employee with how far their salary is above or below their department average?

A.salary - AVG(salary) OVER ()B.salary - AVG(salary) OVER (PARTITION BY dept)C.salary - AVG(salary) OVER (ORDER BY dept)D.salary - AVG(salary) GROUP BY dept

Discussion 0

Join free to post in the discussion.

Salary vs department average

Discussion 0

Related questions