Advertisement
Responsive Ad Unit (Expands to fit width)
Critical Care Readmission Analysis
The hospital wants to identify high-risk patients who were readmitted within 30 days.
Find patients who had multiple admissions where the time between discharge and next admission was 30 days or less. Show:
- Patient first and last name
- Number of readmissions
- Total admission cost across all visits
- Most frequent diagnosis
Order by total cost descending.
Hint: Use self-joins on admissions table with date calculations.
Hard
Editor
Query Result
Run your query to see results