Your question is SQL for Top-Performing Providers. Start with the requirements and the two 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.
Write a SQL query to identify top-performing providers based on specific patient outcome metrics at Evernorth Health Services India.
Use the provided tables to evaluate completed encounters during 2025. Include providers with at least two completed encounters and return the top three providers.
provider_id, provider_name, outcome_success_rate, avg_outcome_score, and completed_encounters.| Column | Type | Description |
|---|---|---|
| provider_idPK | INT | Unique provider identifier |
| provider_name | VARCHAR(100) | Provider's full name |
| specialty | VARCHAR(80) | Provider medical specialty |
| Column | Type | Description |
|---|---|---|
| outcome_idPK | INT | Unique outcome record identifier |
| provider_id | INT | Provider associated with the encounter |
| encounter_date | DATE | Date of the patient encounter |
| outcome_status | VARCHAR(30) | Outcome classification for the encounter |
| outcome_score | DECIMAL(5,2) | Numerical patient outcome score |