Net Salary After Tax
Compute the after-tax salary of each employee. The tax rate depends on the maximum salary inside the company. Return company_id, employee_id, employee_name and salary.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| salary | company_id | employee_id | employee_name |
|---|---|---|---|
| 2550 | 1 | 1 | Alice |
| 4080 | 1 | 2 | Bob |
| 6120 | 1 | 3 | Carol |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in