• No, you are not necessarily returning all instances where StatusId is null, just remove the last three lines:

    ...UNION

    SELECT * FROM Employees

    WHERE StatusId IS NULL