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