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