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