Scenario SQL Question

Employee Count by Department

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

Problem Statement

Count the number of employees in each department. INCLUDE departments with zero employees. Show department_name and employee_count, sorted by employee_count descending then department_name ascending.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping
GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping