Scenario SQL Question

Employee Count by Department and Job

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

Problem Statement

Show one row per (department, job title) pair that has at least one employee. Return department_name, job_title, employee_count. Sort by department_name ascending, then employee_count descending, then job_title ascending.

Relevant Tables

departmentsemployeesjobs

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