Problem Statement

Use a CTE to pre-compute department totals, then display each department with its headcount and total salary expense. Departments with no employees show 0. Return department_id, department_name, total_employees, total_salary_expense — ordered by total_salary_expense DESC, department_id.

Relevant Tables