SELECT
      CODE
    , NAME
    , CNT
    , TTL_AMT
    , AVG_AMT
FROM
( 
SELECT
      OD.CUST_CODE AS CODE
    , CU.CUST_NAME AS NAME
    , COUNT(*) AS CNT
    , sum(ORDER_AMNT) AS TTL_AMT
    , round(avg(ORDER_AMNT)) AS AVG_AMT

    FROM
     ORDERS as OD
     INNER JOIN CUSTOMER as CU
     ON CU.CUST_CODE = OD.CUST_CODE
    WHERE 
     DATE(ORDER_DATE) BETWEEN "2023-09-01" AND "2023-09-30"
    GROUP BY 
     OD.CUST_CODE

) as F
WHERE 
     CNT >= 5
ORDER BY
      CNT   desc
    , AVG_AMT DEsc
    , CODE ASC
;