Write a SQL query to find the average claim amount by month.
Use the claims table and include every month represented in the data. Ignore claim records where the claim amount is NULL.
claim_month, average_claim_amountclaim_month in ascending chronological order| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique identifier for the claim |
| claim_date | DATE | Date the claim was filed |
| claim_amount | DECIMAL(12,2) | Financial amount associated with the claim |