Hospital Patient Flow Dashboard — LOS, Readmissions, Capacity, and Cost

This query produces a comprehensive hospital operations dashboard: current occupancy, length-of-stay distributions, readmission detection, and cost analysis. It is the kind of query a hospital analytics team would schedule nightly to power their operational reporting.

Datasets used: hc_admissions, hc_patients, hc_diagnoses, hc_procedures, hc_wards, hc_lab_results