SQL Exercice – Classify Salary Levels with SQL CASE

Create an additional column named salary_level:

Statement

• If the salary is > 60000 → 'High'
• Between 40000 and 60000 → 'Medium'
• If it is < 40000 → 'Low'

Solution

SELECT 
    full_name,
    salary,
    CASE
        WHEN salary > 60000 THEN 'High'
        WHEN salary BETWEEN 40000 AND 60000 THEN 'Medium'
        ELSE 'Low'
    END AS salary_level
FROM emp
ORDER BY salary DESC;

Extra practice:

1. Run each query in the Query Tool.
2. Modify salary values and test again — you’ll see how the averages and levels change.
3. To save your queries, use File → Save Query (it creates a reusable .sql file).