Write a SQL query to analyze provider onboarding performance by week at Lyra Health, including counts of onboarded providers, average time to onboard, and a comparison to the prior week.
Use completed onboarding records only. Include weekly metrics and prior-week comparisons for weeks represented in the data.
week_start, onboarded_provider_count, avg_days_to_onboard, prior_week_provider_count, week_over_week_count_change, week_over_week_count_change_pct, prior_week_avg_days_to_onboard, and avg_days_change.NULL for prior-week and change fields when no prior week exists.| Column | Type | Description |
|---|---|---|
| provider_idPK | INT | Unique Lyra provider identifier |
| provider_name | VARCHAR(100) | Provider's display name |
| Column | Type | Description |
|---|---|---|
| onboarding_idPK | INT | Unique onboarding record identifier |
| provider_id | INT | Provider associated with the onboarding record |
| started_at | TIMESTAMP | Timestamp when onboarding started |
| completed_at | TIMESTAMP | Timestamp when onboarding was completed |
| status | VARCHAR(20) | Onboarding status |