Super Hard 10

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.