Departments With High Average Salary
Medium
Aggregation & GROUP BY
Return each department_id whose average salary is greater than 60000, together with that average rounded to two decimals. Order by department_id.
Table schema
Employees(id INT PRIMARY KEY, department_id INT, salary INT)Sample data
id | department_id | salary
1 | 1 | 70000
2 | 1 | 65000
3 | 2 | 40000
4 | 2 | 50000
5 | 3 | 90000
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.