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