SELECT
    CODE
    , NAME
    , COUNT(OD)AS CNT
FROM
    (
    SELECT DISTINCT
        o.CUST_CODE AS CODE
        , c.CUST_NAME AS NAME
        , o.ORDER_DATE AS OD
    FROM
        ORDERS AS o
    INNER JOIN
        CUSTOMER AS c
    ON
        o.CUST_CODE = c.CUST_CODE
    WHERE
        o.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
    )
GROUP BY
    CODE
    , NAME
ORDER BY
    CNT DESC, CODE DESC
;