select
    sub.CUST_CODE as CODE
    , CUST_NAME as NAME
    , CNT
    , TTL_AMT
    , ROUND(CAST(TTL_AMT as real) / CNT) as AVG_AMT 
from
    ( 
        select
            CUST_CODE
            , COUNT(ORDER_DATE) as CNT
            , SUM(ORDER_AMNT) as TTL_AMT 
        from
            ORDERS 
        where
            ORDER_DATE between '2023-09-01' and '2023-09-30' 
        group by
            CUST_CODE 
        having
            COUNT(ORDER_DATE)
    ) as sub 
    join CUSTOMER as cs 
        on sub.CUST_CODE = cs.CUST_CODE 
where
    CNT >= 5 
order by
    CNT desc
    , AVG_AMT desc
    , CODE asc 
limit
    5;