WITH ORDERS_2 AS (
    SELECT
        *
    FROM
        ORDERS
    GROUP BY
        CUST_CODE,
        ORDER_DATE
)
SELECT
    CUST_CODE AS 'CODE',
    (
        SELECT CUST_NAME
        FROM CUSTOMER
        WHERE CUSTOMER.CUST_CODE = ORDERS_2.CUST_CODE
    ) AS 'NAME',
    COUNT(*) AS 'CNT'
FROM
    ORDERS_2
GROUP BY
    CUST_CODE
ORDER BY
    `CNT` DESC,
    `CODE`;