Scenario SQL Question
Categorize Employees by Salary Band
Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.
Problem Statement
Categorize employees into salary bands: 'Low Earner' (salary < 30000), 'Average Earner' (30000-60000 inclusive), 'High Earner' (> 60000). Return employee_id, first_name, last_name, salary, salary_band — ordered by employee_id.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: