Cold Case~56min

The Employee Discount That Became a Resale Operation

EMP-042 bought 5 units of HEADPHONE-X on four separate occasions with no authorization on file. Each purchase is followed within 2-3 days by a marketplace listing under "quicksale99" — EMP-042's known alias — for the exact same SKU and quantity. EMP-018 also bought 20 units of one SKU in a single large purchase, which looks similar, but it has a documented manager authorization and no matching listing exists anywhere.

Tables you'll query

employeesdiscount_purchasesmarketplace_listings

What you'll learn

JOINsAggregations & GROUP BYString Functions
Investigate this case →