with tmp as(
    select a.CUST_CODE as CODE,
    a.CUST_NAME as NAME,
    count(*) as CNT,
    sum(ORDER_AMNT) as TTL_AMT,
    round(avg(ORDER_AMNT),0) as AVG_AMT,
    rank() over(order by count(*) desc,
    round(avg(ORDER_AMNT),0) desc,a.cust_code desc) as rn
      from CUSTOMER a Join
           ORDERS b
        on a.cust_code = b.cust_code
       -- and a.emp_code = b.emp_code
     where ORDER_DATE between '2023-09-01' AND '2023-09-30'
    group by a.cust_code/*,a.emp_code*/
    having count(*) >= 5)
    select CODE,NAME,CNT,TTL_AMT,AVG_AMT
      from tmp
     where rn <= 5
    order by rn desc;