Top 10 Patients SQL Query | Dataford Interview Questions

Write a SQL query to retrieve the top 10 patients based on treatment outcomes.

Treat each non-NULL outcome score as a valid treatment outcome and calculate each patient's average score. Return only patients with at least one valid outcome.

Output

One row per patient, with patient_id, patient_name, average_outcome_score, and treatment_count.
Include the 10 highest average scores, ordered descending; break ties by patient_id ascending.

Schema

patients

Column	Type	Description
patient_idPK	INT	Unique patient identifier
patient_name	VARCHAR(100)	Patient's full name
date_of_birth	DATE	Patient date of birth

treatments

Column	Type	Description
treatment_idPK	INT	Unique treatment identifier
patient_id	INT	Patient receiving the treatment
treatment_type	VARCHAR(80)	Type of treatment provided
treatment_date	DATE	Date the treatment occurred
outcome_score	DECIMAL(5,2)	Numeric treatment outcome score

Your question is Top 10 Patients SQL Query. 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