Return customer_id, order_id and order_date of each customer's second order (by date, then order_id). Customers with one order are left out.
7 rows with columns customer_id, order_id, order_date — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 3 | 1008 | 2024-03-15 |
| 2 | 6 | 1015 | 2024-06-15 |
| 3 | 4 | 1025 | 2024-12-15 |
Run your code to see the output here.