Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Departments With High Average Salary

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.