HealthcareMedium
Compute 30-day all-cause readmission rate from admissions data.
Seen at: Sentara · Kaiser · Mayo · Oscar Health
Given an admissions table with (patient_id, admission_date, discharge_date, diagnosis), write SQL to compute the 30-day all-cause readmission rate. A readmission is any subsequent admission for the same patient within 30 days of a prior discharge.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Stuck? Peek at a hint
Reveals the model answer and the self-score rubric.