Tricky~24min

The Claim Above the Limit

Underwriting flagged 4 claims that were approved for more than their own policy's coverage limit — an override slipped past the sub-limit check. About 10 more claims look like they blow through a limit too, but that's only if you match claims to policies by the customer's name instead of the actual policy_id — those customers hold two different policies with very different limits.

Tables you'll query

policiesclaims

What you'll learn

JOINs
Investigate this case →