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
Count employees in different performance categories: 'High Performer' (salary > 70000), 'Medium Performer' (salary 40000-70000), 'Low Performer' (salary < 40000). Return department and count of employees in each category.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: