SELECT
     CODE
   , NAME
   , CNT
   , TTL_AMT
   , AVG_AMT 
FROM
   ( 
      SELECT
           O.CUST_CODE               AS CODE
         , CUST_NAME                 AS NAME
         , COUNT(*)                  AS CNT
         , SUM(ORDER_AMNT)           AS TTL_AMT
         , ROUND(AVG(ORDER_AMNT), 0) AS AVG_AMT 
      FROM
         ORDERS O 
         INNER JOIN CUSTOMER C 
            ON O.CUST_CODE = C.CUST_CODE 
      WHERE
         O.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30' 
      GROUP BY
         O.CUST_CODE
         , CUST_NAME
   ) 
WHERE
   CNT >= 5 
ORDER BY
   CNT DESC
   , AVG_AMT DESC
   , CODE DESC 
LIMIT
   5
;