Cold Case~59min

The Adjuster Who Always Approved Right at the Limit

ADJ-07 approves claims across 4 different claim types clustered 95-98% of the secondary-review threshold — a statistically implausible pattern spanning varied claim types, with 4 claimants repeating across different policies. ADJ-12 also clusters near a threshold, but exclusively handles windshield_replacement claims — a claim type with a naturally fixed cost near that threshold for any adjuster, documented and expected.

Tables you'll query

adjustersclaims

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →