Cold Case~60min
The Chargebacks For Shipments That Arrived Perfectly Fine
Vendor VEN-33 was hit with 5 chargebacks totaling $4,085.00 citing "late_shipment" or "quantity_shortage" — but every one of those 5 shipments has received_qty equal to expected_qty and on_time = true. The shipments were perfect; the violations were fabricated. All 5 were approved by the same compliance rep, REP-CB-06. VEN-08 also has a chargeback, but its shipment shows a real shortage (480 of 600 units received) and a real late delivery — the chargeback matches what actually happened.
Tables you'll query
vendorsshipmentschargebacks
What you'll learn
JOINsAggregations & GROUP BYDate & Time Functions