For each customer with orders, return customer_id, order_id and order_date of their most recent order.
14 rows with columns customer_id, order_id, order_date — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 5 | 1006 | 2024-02-28 |
| 2 | 8 | 1010 | 2024-04-02 |
| 3 | 9 | 1012 | 2024-05-05 |
Run your code to see the output here.