Super Hard 10

SQL Practice

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

Entity Relationship Diagram

Database Schema Diagram