select CODE,NAME,CNT,TTL_AMT,ROUND(TTL_AMT/CNT,1) AS AVG_AMT
FROM    
    (
    select
         o.CUST_CODE as CODE
        ,c.CUST_NAME as NAME
        ,count(o.CUST_CODE) as CNT
        ,SUM(o.ORDER_AMNT) AS TTL_AMT
    from
        ORDERS o
    left join
        CUSTOMER c
    on c.CUST_CODE = o.CUST_CODE
    where o.ORDER_DATE like '2023-09%'
    GROUP BY O.CUST_CODE
    HAVING CNT >= 5
    )V
ORDER BY CNT DESC,AVG_AMT DESC,CODE asc
LIMIT 5