Cold Case~58min

The Return Fraud Ring Hiding in Plain Sight

Five customer accounts all have unusually high return rates. So does CUST-0042, but that one's legitimate — every return has scanned tracking and a wrong_size reason. The other five share the exact same payment card and device ID across "different" accounts, and every single one of their returns has tracking_scanned = false: they never shipped anything back.

Tables you'll query

customersordersreturns

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →