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, o.ORDER_DATE
order by CNT desc, CODE desc