with tmp as (
select
    distinct
    c.cust_code CODE
    ,c.cust_name NAME
    ,o.order_date
from
    orders o 
    left join customer c on o.cust_code = c.cust_code
where
    o.order_date between '2023-07-01' and '2023-07-31'

)
select
    code
    ,name
    ,count(*) CNT
from
    tmp
group by
    code, name
order by
    cnt desc, code desc
;