with result as
(
select
     C.CUST_CODE CODE
    ,MIN(C.CUST_NAME) NAME 
    ,COUNT(C.CUST_NAME) CNT
    ,SUM(O.ORDER_AMNT) TTL_AMT
    ,ROUND( SUM(O.ORDER_AMNT) / COUNT(C.CUST_NAME) ) AVG_AMT
    ,ROW_NUMBER() OVER (ORDER BY COUNT(C.CUST_NAME) DESC,  SUM(O.ORDER_AMNT) DESC, c.CUST_CODE) R
from 
    Orders O
inner join 
    Customer C
ON
    O.Cust_Code  = C.Cust_Code
where order_date between '2023-09-01' AND '2023-09-30'
group by c.CUST_CODE
having CNT >= 5
order by CNT DESC, AVG_AMT DESC, CODE 
)
select CODE, NAME, CNT, TTL_AMT, AVG_AMT from result
where r <= 5
order by r
;