Difference From Department Average
Easy
Window Frames
Return each employee's name and how far their salary is from the department average (salary minus average). Order by name.
Table schema
Employees(id INT PRIMARY KEY, name VARCHAR(50), department_id INT, salary INT)Sample data
id | name | department_id | salary
1 | A | 1 | 100
2 | B | 1 | 200
3 | C | 1 | 300
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.