Calculate the running total (Running Total = Current Value + Immediately Preceding Cumulative Total) of admissions over time. Count admissions per day (daily_admissions) and compute the cumulative total (running_total), ordered by admission_date ascending. Days with no admissions do not need to be included.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Aggregate to one row per day, then accumulate with a window frame ordered by date.