SELECT name, salary,
    CASE
        WHEN salary < 60000 THEN 'Junior'
        WHEN salary < 75000 THEN 'Mid-Level'
        ELSE 'Senior'
    END AS band
FROM employees ORDER BY salary;

SELECT
    SUM(CASE WHEN salary < 60000 THEN 1 ELSE 0 END) AS junior,
    SUM(CASE WHEN salary BETWEEN 60000 AND 74999 THEN 1 ELSE 0 END)
AS mid,
    SUM(CASE WHEN salary >= 75000 THEN 1 ELSE 0 END) AS senior
FROM employees;