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