SQL for Top-Performing Providers | Dataford Interview Questions

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.

Output

One row per provider with provider_id, provider_name, outcome_success_rate, avg_outcome_score, and completed_encounters.
Rank by success rate descending, average score descending, and provider ID ascending as the tie-breaker.

Schema

providers

Column	Type	Description
provider_idPK	INT	Unique provider identifier
provider_name	VARCHAR(100)	Provider's full name
specialty	VARCHAR(80)	Provider medical specialty

patient_outcomes

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

Your question is SQL for Top-Performing Providers. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem