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 ) as ORDERS2 
 group by CUST_CODE 
 having ORDER_DATE between '2023-07-01' and  '2023-07-31'
 order by CNT desc , CODE desc