select
    cs.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