SQL for High Claim Frequency | Dataford Interview Questions

Write a SQL query to find all policyholders who have filed more than two claims in the past year at Berkshire Hathaway Guard Insurance Companies.

Use the policyholders and claims tables. Treat the past year as the period from one year before CURRENT_DATE through CURRENT_DATE, inclusive.

Output

Return one row per qualifying policyholder with policyholder_id, policyholder_name, and claim_count.
Include only policyholders with more than two claims in that period.
Order by claim_count descending, then policyholder_id ascending.

policyholders

Column	Type	Description
policyholder_idPK	INT	Unique policyholder identifier
policyholder_name	VARCHAR(150)	Policyholder's full name

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
policyholder_id	INT	Policyholder associated with the claim
filed_date	DATE	Date the claim was filed

Your question is SQL for High Claim Frequency. 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.