select
     O.CUST_CODE as CODE
    ,C.CUST_NAME as NAME
    ,count(DISTINCT O.ORDER_DATE) as CNT
from
    ORDERS O
inner 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
order by
    CNT desc,CODE desc