Find the orders placed on a Saturday or Sunday in September 2025. Show order_id,
order_date, weekday (the short day name, Sat or Sun) and week_start (the Monday of
that order's week, as a 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 |
Find the orders placed on a Saturday or Sunday in September 2025. Show order_id,
order_date, weekday (the short day name, Sat or Sun) and week_start (the Monday of
that order's week, as a 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 | order_date | weekday | week_start |
|---|---|---|---|
| 25 | 2025-09-06T00:00:00.000Z | Sat | 2025-09-01T00:00:00.000Z |
| 155 | 2025-09-06T00:00:00.000Z | Sat | 2025-09-01T00:00:00.000Z |
| 77 | 2025-09-07T00:00:00.000Z | Sun | 2025-09-01T00:00:00.000Z |
| 88 | 2025-09-07T00:00:00.000Z | Sun | 2025-09-01T00:00:00.000Z |
| 291 | 2025-09-07T00:00:00.000Z | Sun | 2025-09-01T00:00:00.000Z |
| 306 | 2025-09-13T00:00:00.000Z | Sat | 2025-09-08T00:00:00.000Z |
| 58 | 2025-09-14T00:00:00.000Z | Sun | 2025-09-08T00:00:00.000Z |
| 221 | 2025-09-14T00:00:00.000Z | Sun | 2025-09-08T00:00:00.000Z |
| 213 | 2025-09-28T00:00:00.000Z | Sun | 2025-09-22T00:00:00.000Z |
Run query to see output