Your question is Monthly Claims Trend and Anomaly Detection. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |