select
    ord.cust_code as CODE,
    cust_name as NAME,
    count(distinct order_date) as CNT
from
    orders as ord
    inner join customer as cust on ord.cust_code=cust.cust_code
where
    order_date between "2023-07-01" and "2023-07-31"
group by
    NAME
order by
    CNT desc,
    CODE desc
;