Salary Bands

Classify each employee into a salary band: 'Low' if salary < 40000, 'Medium' if salary is between 40000 and 80000 inclusive, 'High' otherwise. Return name and band ordered by id.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), salary INT)

Sample data

id | name | salary
1 | Alice | 30000
2 | Bob | 60000
3 | Carol | 95000