Salary Bands

Problem

Write a query that returns each employee's first_name, last_name, and salary, plus a salary_band column computed with a CASE expression: 'High' if salary >= 100000, 'Mid' if salary >= 75000, and 'Entry' otherwise. Order the results by salary from highest to lowest.

Try It

Hint

Solution