SELECT T1.CUST_CODE CODE
      ,T1.CUST_NAME NAME
      ,T2.CNT CNT
      ,T2.TTL_AMT TTL_AMT
      ,T2.AVG_AMT AVG_AMT
  FROM CUSTOMER T1
  INNER JOIN 
(
SELECT CUST_CODE
      ,COUNT(*) CNT
      ,SUM(ORDER_AMNT) TTL_AMT
      ,ROUND(AVG(ORDER_AMNT)) AVG_AMT
  FROM ORDERS
 WHERE ORDER_DATE >= '2023-09-01'
   AND ORDER_DATE <= '2023-09-30'
 GROUP BY CUST_CODE
) T2
    ON T1.CUST_CODE = T2.CUST_CODE
 ORDER BY CNT DESC,AVG_AMT DESC,CODE