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