Insurance Graded Drills (Easy → Hard)
These drills build insurance analytics fluency in increasing difficulty.
Scoring suggestion:
- Easy drills: pass all
- Medium drills: pass at least one
- Hard drills: pass at least one before moving to capstone
Easy 1: Active Policies by Product Line #
Loading SQL editor...
Easy 2: Policies per Customer #
Loading SQL editor...
Medium 1: Monthly Earned Premium #
Loading SQL editor...
Medium 2: Incurred and Paid by Product Line #
Loading SQL editor...
Hard 1: Loss Ratio by Product Line (Fanout-Safe) #
Loading SQL editor...
Hard 2: Active Policy Claim Rate by Product Line #
Loading SQL editor...
Tip
For insurance metrics, always decide if the business question is at claim grain, policy grain, or product-line grain before writing joins.