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