select o.CUST_CODE as CODE, c.CUST_NAME as NAME, COUNT(*) as CNT from ORDERS as o
inner join CUSTOMER as c
on o.CUST_CODE = c.CUST_CODE
where o.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by o.CUST_CODE
order by CNT desc, CODE desc