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

Department Share of Payroll

Return each department and the percentage of the company payroll it accounts for (rounded to 2 decimals), ordered by department.

Table schema

Employees(id INT PRIMARY KEY, dept VARCHAR(10), salary INT)

Sample data

id | dept | salary
1 | IT | 50000
2 | IT | 70000
3 | HR | 30000
4 | Ops | 50000

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.