SELECT
  C.CUST_CODE AS "CODE"
  , CUST_NAME AS "NAME"
  , COUNT(ORDER_NO) AS "CNT"
  , SUM(ORDER_AMNT) AS "TTL_AMT"
  , SUM(ORDER_AMNT) / COUNT(ORDER_NO) AS "AVG_AMT" 
FROM
  ORDERS AS O 
  INNER JOIN CUSTOMER AS C 
    ON O.CUST_CODE = C.CUST_CODE 
WHERE
  ORDER_DATE >= "2023-09-01" 
  AND ORDER_DATE <= "2023-09-30" 
GROUP BY
  C.CUST_CODE 
HAVING
  COUNT(ORDER_NO) >= 5 
ORDER BY
  COUNT(ORDER_NO) DESC
  , AVG_AMT DESC
  , CODE ASC;