Categorizing Data with CASE

Problem

Select the first_name, salary, and a new column salary_band which is "High" if salary >= 100000, "Medium" if >= 50000, else "Low".

Try It

Hint

Solution