select
    c.cust_code as CODE
    ,c.cust_name as NAME
    ,count(DISTINCT o.ORDER_DATE) as CNT
from
    customer as c
    inner join orders as o
        on o.cust_code = c.cust_code
        and o.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by
    c.cust_code
order by
    CNT desc
    ,CODE desc
;