SQL for Top Providers | Dataford Interview Questions

Write a SQL query to find the top 5 patient providers by number of admissions in the last 12 months.

Use the provider and admission records provided. Count admissions by provider and exclude admissions outside the rolling 12-month period.

Output

One row per provider with admissions in the period.
Columns: provider_name, admission_count.
Return at most five rows, ordered by admission_count descending and provider_id ascending to break ties.

providers

admissions

Column	Type	Description
admission_idPK	INT	Unique admission identifier
provider_id	INT	Provider associated with the admission
patient_id	INT	Patient associated with the admission
admission_date	DATE	Date of admission

Your question is SQL for Top 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.

Write a SQL query to find the top 5 patient providers by number of admissions in the last 12 months.

Use the provider and admission records provided. Count admissions by provider and exclude admissions outside the rolling 12-month period.

One row per provider with admissions in the period.
Columns: provider_name, admission_count.
Return at most five rows, ordered by admission_count descending and provider_id ascending to break ties.

providers

admissions

Column	Type	Description
admission_idPK	INT	Unique admission identifier
provider_id	INT	Provider associated with the admission
patient_id	INT	Patient associated with the admission
admission_date	DATE	Date of admission

Your question is SQL for Top 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.