select CODE,NAME,CNT,TTL_AMT,ROUND(AVG_AMT_S) 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
        ,ROUND(SUM(o.ORDER_AMNT)/count(o.CUST_CODE),1) AS AVG_AMT_S
    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,c.CUST_NAME
    HAVING CNT >= 5
    )V
ORDER BY CNT DESC,AVG_AMT DESC,CODE asc
LIMIT 5