SELECT
  A.CUST_CODE AS CODE
 ,A.CUST_NAME AS NAME
 ,COUNT(B.ORDER_NO) AS CNT
 ,SUM(B.ORDER_AMNT) AS TTL_AMT
 ,ROUND(AVG(B.ORDER_AMNT)) AS AVG_AMT
FROM CUSTOMER A LEFT OUTER JOIN ORDERS B ON (A.CUST_CODE = B.CUST_CODE)
  WHERE B.ORDER_DATE >= '2023-09-01' AND B.ORDER_DATE <= '2023-09-30'
GROUP BY A.CUST_CODE, A.CUST_NAME
HAVING COUNT(B.ORDER_NO) >= 5
ORDER BY
  CNT DESC
 ,AVG_AMT DESC
 ,CODE ASC