select
  t.CUST_CODE as "CODE"
 ,t.CUST_NAME as "NAME"
 ,count(t.CUST_CODE) as "CNT"
from
 (
  select
    c.CUST_CODE
   ,c.CUST_NAME
  from
   ORDERS o
    join
   CUSTOMER c
    on
   c.CUST_CODE = o.CUST_CODE
  where
   o.ORDER_DATE >= '2023-07-01' and o.ORDER_DATE <= '2023-07-31'
  group by
   c.CUST_CODE, o.ORDER_DATE
 ) t
group by
 t.CUST_CODE
order by
 "CNT" desc, "CODE" desc
;