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
where
    o.order_date between '2023-07-01' and '2023-07-31'
group by
    NAME,
    CODE
order by
    CNT desc,
    CODE desc
;