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