For each day (admission_date) between 2025-05-20 and 2025-07-20, show the total number of admissions (total_admissions) and the difference from the previous day (admission_delta). Days with no admissions do not need to be shown. Sort by admission_date in ascending order, the column names and order must match the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Aggregate per day first, then compare each day with the previous one using a window function.