Employee Share of Department Payroll

Calculate each employee's percentage share of their department payroll. Return columns: salary, first_name, department_id, payroll_share. Order results by: department_id, salary DESC.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Calculate each employee's percentage share of their department payroll. Return columns: salary, first_name, department_id, payroll_share. Order results by: department_id, salary DESC.

Difficulty: Advanced
SQL concept: Window Functions

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.