select 
    ORD.CUST_CODE as CODE
    ,CUS.CUST_NAME as NAME
    ,COUNT(ORD.ORDER_NO) as CNT
    ,SUM(ORD.ORDER_AMNT) as TTL_AMT
    ,ROUND(AVG(ORD.ORDER_AMNT)) as AVG_AMT
from CUSTOMER as CUS
inner join ORDERS as ORD on ORD.CUST_CODE = CUS.CUST_CODE
where
    ORD.ORDER_DATE >= '2023-09-01' and ORD.ORDER_DATE <= '2023-09-30' 
group by CODE
having
    count(ORD.ORDER_NO) >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE asc