Cold Case~59min

The Warranty Claims Paid For Parts That Never Shipped Back

Dealer DLR-11 filed 5 warranty claims marked core_returned = true — required to collect the $150.00 core charge on top of the repair reimbursement — but not one of those 5 claims has a matching core_return_shipments record. No tracking number, no shipment, nothing. $750.00 in core charges was paid for parts that were never actually sent back for inspection. DLR-06's claim is also marked core_returned = true and the matching shipment arrived 11 days later than usual, but it did arrive, with a real tracking number on file. Slow, not fabricated.

Tables you'll query

dealerswarranty_claimscore_return_shipments

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →