select ORD.CUST_CODE CODE
     , CUST.CUST_NAME NAME
     , count(*) CNT
from (select distinct
             ORD0.CUST_CODE CUST_CODE
           , ORD0.ORDER_DATE ORDER_DATE
      from ORDERS ORD0
     ) ORD
   , CUSTOMER CUST
where ORD.CUST_CODE = CUST.CUST_CODE
and   ORD.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by CUST.CUST_CODE
order by count(*) desc
       , ORD.CUST_CODE desc