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