Use only delivered orders placed from 1 July to 30 September 2025. Make one row per
order_date that has such orders, with day_revenue (that day's total total_amount). Then show
order_date, day_revenue and last_30_days: the revenue of that day plus the 29 calendar days
before it.
End your query with ORDER BY order_date.
| orders |
|---|
| order_id (PK) |
| order_date |
| status |
| total_amount |
Use only delivered orders placed from 1 July to 30 September 2025. Make one row per
order_date that has such orders, with day_revenue (that day's total total_amount). Then show
order_date, day_revenue and last_30_days: the revenue of that day plus the 29 calendar days
before it.
End your query with ORDER BY order_date.
| orders |
|---|
| order_id (PK) |
| order_date |
| status |
| total_amount |
| order_date | day_revenue | last_30_days |
|---|---|---|
| 2025-07-11T00:00:00.000Z | 4698.00 | 4698.00 |
| 2025-07-13T00:00:00.000Z | 5473.15 | 10171.15 |
| 2025-07-16T00:00:00.000Z | 12996.00 | 23167.15 |
| 2025-07-26T00:00:00.000Z | 14995.20 | 38162.35 |
| 2025-08-04T00:00:00.000Z | 5748.10 | 43910.45 |
| 2025-08-05T00:00:00.000Z | 8247.10 | 52157.55 |
| 2025-09-02T00:00:00.000Z | 11496.20 | 25491.40 |
| 2025-09-07T00:00:00.000Z | 22217.25 | 33713.45 |
| 2025-09-14T00:00:00.000Z | 8322.05 | 42035.50 |
| 2025-09-15T00:00:00.000Z | 11996.00 | 54031.50 |
| 2025-09-17T00:00:00.000Z | 11571.45 | 65602.95 |
| 2025-09-25T00:00:00.000Z | 15669.75 | 81272.70 |
| 2025-09-28T00:00:00.000Z | 8147.10 | 89419.80 |
Run query to see output