select CODE,NAME,CNT,TTL_AMT,AVG_AMT
from 
(
SELECT CODE,NAME,CNT,TTL_AMT,AVG_AMT,rank() over(order by CNT,AVG_AMT,CODE) r
FROM 
(SELECT
A.CUST_CODE CODE
,B.CUST_NAME NAME
,COUNT(A.CUST_CODE) CNT
,SUM(A.ORDER_AMNT) TTL_AMT
,round(AVG(A.ORDER_AMNT),0) AVG_AMT

FROM ORDERS A 
LEFT JOIN CUSTOMER B ON A.CUST_CODE= B.CUST_CODE
where ORDER_DATE between '2023-09-01' and  '2023-09-30'
group by A.CUST_CODE
having COUNT(A.CUST_CODE) >4
) C
)
where r<6
order by 
3 desc
,5 desc
,1 desc