Routine~11min

The Ghost Department

HR deleted 3 departments last quarter during a reorg. Someone just pointed out that a chunk of employees still show those departments as their primary assignment — their cost centre, reporting line, and system access all reference a department that no longer exists.

Tables you'll query

departmentsemployees

What you'll learn

JOINs
Investigate this case →