MediumSQL
Label Employees by Salary Band
SQLDatabases
Write a SQL query that adds a band column to each employee row:
'Senior'— salary ≥ 90 000'Mid'— salary 50 000 – 89 999'Junior'— salary < 50 000
Return name, salary, band, ordered by salary descending.
Table: employees
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 95000 |
| 2 | Bob | Marketing | 52000 |
| 3 | Carol | Engineering | 68000 |
| 4 | Dave | Sales | 38000 |
| 5 | Eve | Engineering | 120000 |
| 6 | Frank | Marketing | 45000 |
Expected output
Eve|120000|Senior
Alice|95000|Senior
Carol|68000|Mid
Bob|52000|Mid
Frank|45000|Junior
Dave|38000|JuniorSample tests
Test #12 Senior, 2 Mid, 2 Junior
Input: "CREATE TABLE employees (id INTEGER, name TEXT, department TEXT, salary INTEGER);\nINSERT INTO employees VALUES\n (1, 'Alice', 'Engineering', 95000),\n (2, 'Bob', 'Marketing', 52000),\n (3, 'Carol', 'Engineering', 68000),\n (4, 'Dave', 'Sales', 38000),\n (5, 'Eve', 'Engineering', 120000),\n (6, 'Frank', 'Marketing', 45000);"
Output: "Eve|120000|Senior\nAlice|95000|Senior\nCarol|68000|Mid\nBob|52000|Mid\nFrank|45000|Junior\nDave|38000|Junior"