For customers 1 and 2, show customer_id, order_id, order_date and
order_number: 1 for the customer's first order, 2 for their second, and so on, counting by
order_date and then order_id.
End your query with ORDER BY customer_id, order_number.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
For customers 1 and 2, show customer_id, order_id, order_date and
order_number: 1 for the customer's first order, 2 for their second, and so on, counting by
order_date and then order_id.
End your query with ORDER BY customer_id, order_number.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| customer_id | order_id | order_date | order_number |
|---|---|---|---|
| 1 | 168 | 2024-06-24T00:00:00.000Z | 1 |
| 1 | 32 | 2024-08-27T00:00:00.000Z | 2 |
| 1 | 218 | 2024-10-09T00:00:00.000Z | 3 |
| 1 | 292 | 2024-11-18T00:00:00.000Z | 4 |
| 1 | 30 | 2024-11-27T00:00:00.000Z | 5 |
| 1 | 117 | 2025-01-11T00:00:00.000Z | 6 |
| 1 | 210 | 2025-01-26T00:00:00.000Z | 7 |
| 1 | 152 | 2025-03-19T00:00:00.000Z | 8 |
| 1 | 1 | 2025-06-02T00:00:00.000Z | 9 |
| 1 | 228 | 2025-08-17T00:00:00.000Z | 10 |
| 1 | 48 | 2025-10-14T00:00:00.000Z | 11 |
| 2 | 223 | 2024-03-06T00:00:00.000Z | 1 |
| 2 | 238 | 2024-03-15T00:00:00.000Z | 2 |
| 2 | 121 | 2024-04-30T00:00:00.000Z | 3 |
| 2 | 285 | 2024-06-20T00:00:00.000Z | 4 |
| 2 | 275 | 2024-06-24T00:00:00.000Z | 5 |
| 2 | 91 | 2024-11-06T00:00:00.000Z | 6 |
| 2 | 217 | 2024-11-06T00:00:00.000Z | 7 |
| 2 | 282 | 2024-12-30T00:00:00.000Z | 8 |
| 2 | 143 | 2025-01-09T00:00:00.000Z | 9 |
| 2 | 131 | 2025-02-02T00:00:00.000Z | 10 |
| 2 | 39 | 2025-03-09T00:00:00.000Z | 11 |
| 2 | 193 | 2025-03-13T00:00:00.000Z | 12 |
| 2 | 279 | 2025-03-17T00:00:00.000Z | 13 |
| 2 | 2 | 2025-07-11T00:00:00.000Z | 14 |
| 2 | 291 | 2025-09-07T00:00:00.000Z | 15 |
| 2 | 123 | 2025-09-25T00:00:00.000Z | 16 |
Run query to see output