Scenario SQL Question

Departments with Above Average Employee Count

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

Problem Statement

Find departments whose employee count exceeds the average department size (computed across departments that actually have employees). Return department_id, department_name, employee_count — ordered by employee_count DESC, department_id.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Subquery Types & ClassificationSubqueries & CTEs
Correlated SubqueriesSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs