📌 Exercise Overview This exercise demonstrates the use of SQL date functions to extract, transform, and analyse date-based data in different business scenarios. The dataset includes multiple small ...
• Logic: Built by first utilizing a DATEDIFF calculation between a patient's Admission_Date and Discharge_Date to establish individual lengths of stay (LOS_Days). A standard DAX AVERAGE function is ...