Cold Case~60min

The Ghost Contractor Payroll

CTR-014's contract ended February 28th with no extension on file, but invoices for "hours worked" continued monthly through October — 8 months of payments to someone whose contract had ended. Every one of those invoices was approved by a manager who themselves departed the company on March 1st. 6 other contractors also have invoices past their original end date, but each has a documented extension on file.

Tables you'll query

managerscontractorscontract_extensionsinvoices

What you'll learn

JOINsSubqueriesDate & Time Functions
Investigate this case →