select 
    CUS.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
group by CODE
having 
    ORD.ORDER_DATE > '2023-09-01 00:00:00' and ORD.ORDER_DATE < '2023-09-30 23:59:59' 
and 
    count(ORD.ORDER_NO) >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE asc