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