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