Routine~14min

The Phantom Department

18 employees are assigned to a department that doesn't exist in the system. They've been on payroll for months. No manager. No budget. No record. Just the salary going out.

Tables you'll query

departmentsemployeespayroll

What you'll learn

JOINsNULL Handling
Investigate this case →