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