Write a SQL query to join customer and policy tables and return the total premium by customer for Plymouth Rock Assurance.
Include customers who do not have any policies, showing their total premium as zero. Exclude policies that are not associated with a customer.
customer_id, customer_name, and total_premium.total_premium descending and customer_id ascending for ties.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer's full name |
| Column | Type | Description |
|---|---|---|
| policy_idPK | INT | Unique policy identifier |
| customer_id | INT | Customer associated with the policy |
| premium | NUMERIC(12,2) | Premium amount for the policy |