with tmp_tbl as 
(
  select 
    cust_code
    ,order_date
  from orders 
  group by 1,2
)
select 
  o.cust_code as CODE 
  ,c.cust_name as NAME 
  ,count(0) as CNT
from tmp_tbl as o
inner join customer as c 
  on o.cust_code = c.cust_code 
where o.order_date >= '2023-07-01'
  and o.order_date < '2023-08-01'
group by 1,2
order by CNT desc, CODE desc
;