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