WITH T as (
SELECT
 CUST_CODE 
,COUNT(*) COUNT
,SUM(ORDER_AMNT) SUM_AMT
,ROUND(AVG(ORDER_AMNT), 0) AVG_AMT
FROM ORDERS
WHERE ORDER_DATE >= '2023-09-01' and ORDER_DATE < '2023-10-01'
GROUP BY CUST_CODE 
HAVING COUNT(*) >= 5
), A as (
SELECT
 T.CUST_CODE as CODE
,C.CUST_NAME as NAME
,COUNT as CNT
,SUM_AMT as TTL_AMT
,AVG_AMT as AVG_AMT
,ROW_NUMBER() over (ORDER BY COUNT desc, SUM_AMT desc, AVG_AMT) rn
FROM T
JOIN CUSTOMER C ON T.CUST_CODE = C.CUST_CODE
)

SELECT
 CODE,NAME, CNT, TTL_AMT, AVG_AMT
FROM A
ORDER BY rn