Department Share of Payroll
Medium
Percent & Share Calculations
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.