SELECT
    CUST_CODE AS CODE,
    CUST_NAME AS NAME
FROM
    ORDERS
    INNER JOIN CUSTOMER ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
GROUP BY
    CODE, NAME, ORDER_DATE