with vOdr as
(select 
	 o.CUST_CODE
	,c.CUST_NAME
	,o.ORDER_DATE
	from ORDERS o
	inner join CUSTOMER 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
	,c.CUST_NAME
	,o.ORDER_DATE)
select 
 od.CUST_CODE CODE
,od.CUST_NAME NAME
,count(*) cnt
from vOdr od
group by
 od.CUST_CODE 
,od.CUST_NAME 
order by
 count(*) desc
,od.CUST_CODE