select
  t2.cust_code CODE,
  c.cust_name NAME,
  t2.cnt CNT
from (
  select
    cust_code,
    count(1) cnt
  from (
    select
      distinct cust_code, order_date
    from
      orders
    where
      order_date between '2023-07-01' and '2023-07-31'
  ) t1
  group by cust_code
) t2
INNER JOIN
  customer c
on
  t2.cust_code = c.cust_code
order by CNT desc, CODE desc
;