Advanced · SQL · Window functions

Salary difference from team average

Commonly asked: QA data-validation rounds · ~10 min

Return name, team, salary and diff (salary minus the team's average salary, rounded to 0 decimals). Sort by team, then diff descending, then name.