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