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