Scenario SQL Question

Conditional Aggregation - Count by Performance Level

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

Problem Statement

For each department, count employees in three performance bands: 'High Performer' (salary > 70000), 'Medium Performer' (40000-70000 inclusive), 'Low Performer' (< 40000). Return department_id, high_performers, medium_performers, low_performers — ordered by department_id.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

CASE Statements & Conditional LogicSQL Fundamentals
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
Complex WHERE Conditions & Boolean LogicAdvanced Filtering