select
    od.CUST_CODE as CODE
    , cs.CUST_NAME as NAME
    , COUNT(DISTINCT od.ORDER_NO) as CNT 
from
    orders as od 
    inner join customer as cs 
        on od.CUST_CODE = cs.CUST_CODE 
where
    od.ORDER_DATE between '2023-07-01' and '2023-07-31' 
group by
    cs.CUST_NAME
    , od.cust_code 
order by
    CNT desc
    , CODE desc