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