A streak is a run of consecutive days on which the shop had at least one order. Find the streaks in 2025 that last 4 days or more, and show:
run_start: the first day of the streakrun_end: the last daydays: how many days it lastsEnd your query with ORDER BY days DESC, run_start.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
A streak is a run of consecutive days on which the shop had at least one order. Find the streaks in 2025 that last 4 days or more, and show:
run_start: the first day of the streakrun_end: the last daydays: how many days it lastsEnd your query with ORDER BY days DESC, run_start.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| run_start | run_end | days |
|---|---|---|
| 2025-06-24T00:00:00.000Z | 2025-06-30T00:00:00.000Z | 7 |
| 2025-05-17T00:00:00.000Z | 2025-05-22T00:00:00.000Z | 6 |
| 2025-07-08T00:00:00.000Z | 2025-07-11T00:00:00.000Z | 4 |
| 2025-08-31T00:00:00.000Z | 2025-09-03T00:00:00.000Z | 4 |
| 2025-09-12T00:00:00.000Z | 2025-09-15T00:00:00.000Z | 4 |
Run query to see output