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
from
    ORDERS o
left join
    CUSTOMER c
on c.CUST_CODE = o.CUST_CODE
where o.ORDER_DATE like '2023-09%'
--and RANK() OVER(ORDER BY TTL_AMT DESC) < 5
GROUP BY O.CUST_CODE
HAVING CNT >= 5
ORDER BY CNT DESC,AVG_AMT DESC,CODE asc
LIMIT 5