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