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