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( 1.0 * 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
    ;