2025-08-16 10:15:31 +0000 UTC

Employees Whose Manager Left the Company

Code

SELECT
    employee_id
FROM
    Employees
WHERE
    manager_id NOT IN (
        SELECT
            employee_id
        FROM
            Employees
    ) 
    AND salary < 30000
ORDER BY
    employee_id