select 
od.CUST_CODE as CODE
,cus.CUST_NAME as NAME
,count(od.ORDER_NO) as CNT
,sum(od.ORDER_AMNT) as TTL_AMT
,round((sum(od.ORDER_AMNT)*1.0)/count(od.ORDER_NO),0) as AVG_AMT
from ORDERS od
left join CUSTOMER cus
on od.CUST_CODE = cus.CUST_CODE
where od.ORDER_DATE >='2023-09-01'
and od.ORDER_DATE <= '2023-09-30'
group by od.CUST_CODE
having CNT >= 5
order by 
 CNT desc
,TTL_AMT desc
,CODE asc