Analyze monthly claim payment trends in Global Healthcare Exchange data and identify provider-month anomalies in Q1 2024. Your query should keep months with no approved claims, summarize approved activity by provider and month, compute each provider's average monthly paid amount across the quarter, and classify each month as Anomaly or Normal using a 20% threshold from that average.
| Column | Type | Description |
|---|---|---|
| provider_id | ||
| provider_name |
| Column | Type | Description |
|---|---|---|
| claim_id | ||
| provider_id | ||
| member_id | ||
| claim_date | ||
| status | ||
| paid_amount |
| Column | Type | Description |
|---|---|---|
| month_start | ||
| month_label |
provider_namemonth_labelapproved_claimstotal_paid_amountavg_monthly_paid_q1anomaly_flag