Try it Yourself: SQL Case – Hyring Learn

LessonBack to lesson

SQL Case

Language: SQL

SELECT first_name,
       salary,
       CASE
         WHEN salary >= 80000 THEN 'High'
         WHEN salary >= 50000 THEN 'Medium'
         ELSE 'Entry'
       END AS salary_band
FROM employees;

SELECT first_name,
       salary,
       CASE
         WHEN salary >= 80000 THEN 'High'
         WHEN salary >= 50000 THEN 'Medium'
         ELSE 'Entry'
       END AS salary_band
FROM employees;

Output

Click Run to execute this code.