Consecutive Twelve-Month Claim Count | Dataford Interview Questions

Write a query to identify policyholders who have submitted more than two claims within a consecutive twelve-month window.

Use the provided policyholder and claim data. Treat claims occurring exactly twelve months apart as being within the same window.

Output

One row per qualifying policyholder.
Columns: policyholder_id, policyholder_name, and max_claims_in_12_month_window.
Include only policyholders with more than two claims in at least one twelve-month window, ordered by policyholder_id ascending.

policyholders

Column	Type	Description
policyholder_idPK	INT	Unique policyholder identifier
policyholder_name	VARCHAR(100)	Policyholder full name

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
policyholder_id	INT	Policyholder associated with the claim
claim_date	DATE	Date the claim was submitted
claim_status	VARCHAR(20)	Current claim status

Your question is Consecutive Twelve-Month Claim Count. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.