Cold Case~63min

The Rebuilt Wrecks Insured Like They Were Never Wrecked

5 vehicles have a salvage record (a prior total-loss claim) dated before their current policy started, yet all 5 policies mark salvage_disclosed = false and insure the vehicle at full, undiscounted value — $115,600.00 in exposure the insurer never should have carried. All 5 were written by the same agent, AGT-19, who should have caught the VIN history. VIN-LEGIT-01 also has a salvage record before its policy, but that policy correctly marks salvage_disclosed = true and insures it at a discounted $11,200.00 — properly handled, not fraud.

Tables you'll query

vehiclessalvage_recordspolicies

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →