select 
    ORDERS.CUST_CODE as CODE
    , CUSTOMER.CUST_NAME as NAME
    , count(distinct(ORDERS.ORDER_DATE)) as CNT
from 
    ORDERS 
    inner join 
        CUSTOMER 
        on 
            CUSTOMER.CUST_CODE = ORDERS.CUST_CODE 
where 
    ORDERS.ORDER_DATE 
    between 
        '2023-07-01' and '2023-07-31'
group by 
    CODE 
order by 
    CNT desc
    , CODE desc
;