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