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