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