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),1) as AVG_AMT,
Row_Number() over(order by count(*) desc,
round(avg(ORDER_AMNT),1) 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;