Write a SQL query to join policyholder data with claims history and find the average claim amount per region for American Family Insurance.
Use the provided policyholder and claims tables. Include only regions associated with policyholders who have claims, ignore claims with missing amounts, and round averages to two decimal places.
region and average_claim_amount.| Column | Type | Description |
|---|---|---|
| policyholder_idPK | INT | Unique policyholder identifier |
| policyholder_name | VARCHAR(100) | Policyholder full name |
| region | VARCHAR(50) | Geographic region associated with the policyholder |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| policyholder_id | INT | Policyholder associated with the claim |
| claim_amount | DECIMAL(12,2) | Financial amount requested for the claim |