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