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