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