Employee Share of Department Payroll

Calculate each employee's percentage share of their department payroll. Return columns: first_name, department_id, salary, 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: first_name, department_id, salary, payroll_share. Order results by: department_id, salary DESC.

Difficulty: Advanced
SQL concept: Window Functions