Your question is Policies and Premium SQL. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
customer_id.| Column | Type | Description |
|---|---|---|
| customer_idPK | INTEGER | Unique GEICO customer identifier |
| customer_name | VARCHAR(100) | Customer's full name |
| 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 |