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