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