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