select
  C.CUST_CODE as CODE
, C.CUST_NAME as NAME
, count(O.ORDER_DATE) as CNT
from
  (select distinct
     ORDER_DATE
   , CUST_CODE
   from 
     ORDERS
   where
     ORDER_DATE between '2023-07-01' and '2023-07-31') O
  inner join CUSTOMER C
     on O.CUST_CODE = C.CUST_CODE
group by
  C.CUST_CODE
, C.CUST_NAME
order by
  count(O.ORDER_DATE) desc
, C.CUST_CODE desc