Complex~36min

The Claim Frequency That Spikes Right Before Non-Renewal

12 non-renewing policyholders filed just 1 claim across the first 10 months of their policy, then suddenly filed 5 more in the final 2 months before lapsing — a rolling monthly claim rate spike far above their own baseline right before leaving. 8 more non-renewing policyholders show the exact same late-period spike, but every one of those late claims is tied to a documented regional flood event.

Tables you'll query

policiesclaims

What you'll learn

CTEs (WITH clause)Window FunctionsAggregations & GROUP BY
Investigate this case →