WITH TEMP AS(
  SELECT CUST_CODE 
        ,COUNT(CUST_CODE) CNT
        ,ROUND(SUM(ORDER_AMNT)) TTL_AMT
        ,ROUND(AVG(ORDER_AMNT)) AVG_AMT
    FROM ORDERS
   WHERE ORDER_DATE >= '2023-09-01'
     AND ORDER_DATE <= '2023-09-31'
   GROUP BY CUST_CODE
), RK1 AS (
  SELECT *
    FROM TEMP
   WHERE TEMP.CNT >= 5
), RK2 AS (
  SELECT CUST_CODE
        ,CNT
        ,TTL_AMT
        ,AVG_AMT
        ,RANK() OVER(ORDER BY CNT DESC, AVG_AMT DESC, CUST_CODE) RNK
    FROM RK1
)
SELECT RK2.CUST_CODE CODE
      ,CS.CUST_NAME NAME
      ,RK2.CNT
      ,RK2.TTL_AMT
      ,RK2.AVG_AMT
 FROM RK2
INNER JOIN CUSTOMER CS
   ON RK2.CUST_CODE = CS.CUST_CODE
WHERE RK2.RNK <= 5
ORDER BY CNT DESC
        ,AVG_AMT
        ,CODE