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