For customer 7, show order_id, order_date and, counting by order_date and then
order_id:
previous_order_date: the date of the order before this one (NULL for the first order)days_since_previous: the number of days between the two (NULL for the first order)End your query with ORDER BY order_date, order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
For customer 7, show order_id, order_date and, counting by order_date and then
order_id:
previous_order_date: the date of the order before this one (NULL for the first order)days_since_previous: the number of days between the two (NULL for the first order)End your query with ORDER BY order_date, order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| order_id | order_date | previous_order_date | days_since_previous |
|---|---|---|---|
| 72 | 2024-01-08T00:00:00.000Z | NULL | NULL |
| 87 | 2024-03-31T00:00:00.000Z | 2024-01-08T00:00:00.000Z | 83 |
| 243 | 2024-05-26T00:00:00.000Z | 2024-03-31T00:00:00.000Z | 56 |
| 100 | 2024-06-23T00:00:00.000Z | 2024-05-26T00:00:00.000Z | 28 |
| 236 | 2024-07-09T00:00:00.000Z | 2024-06-23T00:00:00.000Z | 16 |
| 24 | 2024-09-16T00:00:00.000Z | 2024-07-09T00:00:00.000Z | 69 |
| 57 | 2024-09-21T00:00:00.000Z | 2024-09-16T00:00:00.000Z | 5 |
| 225 | 2024-09-27T00:00:00.000Z | 2024-09-21T00:00:00.000Z | 6 |
| 273 | 2025-01-28T00:00:00.000Z | 2024-09-27T00:00:00.000Z | 123 |
| 111 | 2025-03-04T00:00:00.000Z | 2025-01-28T00:00:00.000Z | 35 |
| 120 | 2025-05-20T00:00:00.000Z | 2025-03-04T00:00:00.000Z | 77 |
| 183 | 2025-05-20T00:00:00.000Z | 2025-05-20T00:00:00.000Z | 0 |
| 161 | 2025-07-26T00:00:00.000Z | 2025-05-20T00:00:00.000Z | 67 |
| 37 | 2025-08-04T00:00:00.000Z | 2025-07-26T00:00:00.000Z | 9 |
| 3 | 2025-09-05T00:00:00.000Z | 2025-08-04T00:00:00.000Z | 32 |
Run query to see output