Complex~35min

The Readmission That Doesn't Count as a Readmission

10 patients came back within 3 days of discharge for the same issue, but their return visit was classified as observation instead of inpatient — off the books for the official 30-day inpatient readmission metric, even though it's a real readmission clinically. 8 more patients also have an observation visit after an earlier inpatient stay, but the gap is 60 days — an unrelated later visit, not a readmission.

Tables you'll query

patientsadmissions

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →