SELECT
 c.CUST_CODE as  CODE
 ,CUST_NAME as  NAME
 ,COUNT(c.CUST_CODE) as  CNT
FROM
 ORDERS as o inner join CUSTOMER as c on o.CUST_CODE = c.CUST_CODE
where 
 ORDER_DATE between '2023-07-01' and '2023-07-31'
GROUP BY 
 CODE,NAME
ORDER BY 
 CNT desc
 ,CODE desc;