SQL For Multiple Active Policies | Dataford Interview Questions

Write a SQL query to identify policyholders who have multiple active policies across different product lines.

Use the policyholders and policies tables. Treat policies with status Active as active.

Output

Return one row per qualifying policyholder.
Include policyholder_id, policyholder_name, active_policy_count, and product_lines.
Include only policyholders with active policies in at least two distinct product lines.
Sort by policyholder_id ascending.

policyholders

Column	Type	Description
policyholder_idPK	INT	Unique identifier for the policyholder
policyholder_name	VARCHAR(100)	Full name of the policyholder
email	VARCHAR(150)	Policyholder email address

policies

Column	Type	Description
policy_idPK	INT	Unique identifier for the policy
policyholder_id	INT	Policyholder associated with the policy
product_line	VARCHAR(80)	Insurance product line for the policy
status	VARCHAR(20)	Current policy status
effective_date	DATE	Date coverage became effective
expiration_date	DATE	Date coverage expires

Your question is SQL For Multiple Active Policies. 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.