Policies and Premium SQL | Dataford Interview Questions

GEICO's Business Analytics team needs a customer-level view of policy concentration and annual premium. Write a PostgreSQL query that identifies customers who hold multiple policies.

Requirements

Join customers to their policies using customer_id.
Return each qualifying customer's ID, name, policy count, and total annual premium.
Include only customers with more than one policy, and sort by total annual premium descending, then customer ID ascending.

Schema

geico_customers

Column	Type	Description
customer_idPK	INTEGER	Unique GEICO customer identifier
customer_name	VARCHAR(100)	Customer's full name

geico_policies

Column	Type	Description
policy_idPK	INTEGER	Unique policy identifier
customer_id	INTEGER	References geico_customers.customer_id
policy_number	VARCHAR(30)	GEICO policy number
policy_type	VARCHAR(30)	Coverage category
annual_premium	NUMERIC(12,2)	Annual premium amount in dollars

Your question is Policies and Premium SQL. 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.

Problem