SELECT Customer_id, Order_no, Order_date ; FROM Orders ; WHERE DTOC(DATE())+STR(order_pk) IN (; SELECT MAX(DTOC(DATE())+STR(Order_pk)) FROM ORDERS GROUP BY Customer_id)