IntermediateBasic SELECT

Select employees using CASE to label salary brackets

The query

SQL

SELECT
  first_name,
  last_name,
  salary,
  CASE
    WHEN salary < 40000 THEN 'Junior'
    WHEN salary BETWEEN 40000 AND 80000 THEN 'Mid-Level'
    WHEN salary BETWEEN 80001 AND 120000 THEN 'Senior'
    ELSE 'Executive'
  END AS salary_bracket
FROM employees
ORDER BY salary;

Tested against PostgreSQL 16

Note

“CASE WHEN is the SQL equivalent of if-else. It can appear in SELECT, WHERE, ORDER BY.

Tables referenced

employees10 cols