Given a schema with claims and policyholder tables, write a query to find the total claims paid per state over the last fiscal year.
Assume the last completed fiscal year ran from July 1, 2025 through June 30, 2026. Include only paid claims with a known policyholder state.
state, total_claims_paid| Column | Type | Description |
|---|---|---|
| policyholder_idPK | INT | Unique policyholder identifier |
| state | VARCHAR(50) | U.S. state of the policyholder |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| policyholder_id | INT | Policyholder associated with the claim |
| claim_status | VARCHAR(20) | Claim processing status |
| paid_date | DATE | Date the claim payment was issued |
| paid_amount | DECIMAL(12,2) | Amount paid for the claim |