with ORD as(
select
	 CUST_CODE 
	,count(*) as CNT
	,sum(ORDER_AMNT) as TTL_AMT
	,avg(ORDER_AMNT) as AVG_AMT
from ORDERS
where ORDER_DATE between '2023-09-01' and '2023-09-30'
group by CUST_CODE
)
select
	 o.CUST_CODE as CODE
	,c.CUST_NAME as NAME
	,o.CNT as CNT
	,o.TTL_AMT as TTL_AMT
	,ROUND(o.AVG_AMT, 0) as AVG_AMT
from ORD o
	 inner join CUSTOMER c
	 on o.CUST_CODE = c.CUST_CODE
where
	o.CNT >= 5
order by
	CNT desc, AVG_AMT desc, CODE
limit 5