Write a SQL query to calculate running totals of monthly claims for Plymouth Rock Assurance.
Use the claims table and include all claim records with a non-null claim date. Return one row for each calendar month represented in the data.
claim_month, monthly_claims, and running_totalclaim_month must use YYYY-MM format.| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| claim_date | DATE | Date the claim was reported |
| claim_amount | DECIMAL(12,2) | Financial amount associated with the claim |