select
    CUST_CODE as CODE,
    CUST_NAME as NAME,
    CNT as CNT,
    TTL_AMT as TTL_AMT,
    AVG_AMT as AVG_AMT
from
    (
    select
        TBL1.CUST_CODE,
        CUST_NAME,
        count(CUST_NAME) as CNT,
        sum(ORDER_AMNT) as TTL_AMT,
        round(avg(ORDER_AMNT)) as AVG_AMT
    from
        ORDERS as TBL1
    left outer join CUSTOMER as TBL2 on TBL1.CUST_CODE  = TBL2.CUST_CODE 
    where '2023-09-01' <= ORDER_DATE and ORDER_DATE <= '2023-09-30'
    group by TBL1.CUST_CODE,CUST_NAME
    ) as TBL3
where
    CNT >= 5
order by CNT desc,AVG_AMT desc,CODE asc
limit 5