Scenario SQL Question

Basic CTE for Department Summary

Build mastery in Ctes Window with this scenario-based SQL challenge and live execution support.

Problem Statement

Use a CTE to first calculate department totals, then display department name, total employees, and total salary expense for all departments.

departmentsemployees