Orders are delivered within a week. For every order placed in October 2025, show
order_id, placed_on (the order date as text in the form 01 Oct 2025) and deliver_by (the
date 7 days after the order date).
End your query with ORDER BY order_date, order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
Orders are delivered within a week. For every order placed in October 2025, show
order_id, placed_on (the order date as text in the form 01 Oct 2025) and deliver_by (the
date 7 days after the order date).
End your query with ORDER BY order_date, order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| order_id | placed_on | deliver_by |
|---|---|---|
| 4 | 01 Oct 2025 | 2025-10-08T00:00:00.000Z |
| 203 | 01 Oct 2025 | 2025-10-08T00:00:00.000Z |
| 197 | 02 Oct 2025 | 2025-10-09T00:00:00.000Z |
| 48 | 14 Oct 2025 | 2025-10-21T00:00:00.000Z |
| 51 | 14 Oct 2025 | 2025-10-21T00:00:00.000Z |
| 170 | 14 Oct 2025 | 2025-10-21T00:00:00.000Z |
| 264 | 15 Oct 2025 | 2025-10-22T00:00:00.000Z |
| 311 | 15 Oct 2025 | 2025-10-22T00:00:00.000Z |
| 5 | 20 Oct 2025 | 2025-10-27T00:00:00.000Z |
Run query to see output