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