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