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