codejump
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`

idnamedepartmentsalary
1AliceEngineering95000
2BobMarketing52000
3CarolEngineering68000
4DaveSales38000
5EveEngineering120000
6FrankMarketing45000

Expected output

Eve|120000|Senior
Alice|95000|Senior
Carol|68000|Mid
Bob|52000|Mid
Frank|45000|Junior
Dave|38000|Junior

Sample 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"
← All challenges