SELECT
    CUST_CODE AS CODE,
    MAX(CUST_NAME) AS NAME,
    COUNT(*) AS CNT,
    SUM(ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(ORDER_AMNT)) AS AVG_AMT
FROM
    ORDERS
    INNER JOIN CUSTOMER USING (CUST_CODE)
WHERE
    '2023-09-01' <= ORDER_DATE
    AND ORDER_DATE < '2023-10-01'
GROUP BY
    CUST_CODE
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC
LIMIT
    5