HealthcareHard
Flag length-of-stay outliers with SQL.
Seen at: HCA · Epic · Ascension
You have encounters(encounter_id, patient_id, drg_code, admit_ts, discharge_ts). Write SQL that flags encounters whose LOS is statistically unusual relative to their DRG.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Reveals the model answer and the self-score rubric.