SELECT 
    CODE,NAME,CNT,TTL_AMT,AVG_AMT
FROM
(
SELECT
C.CUST_CODE CODE,
C.CUST_NAME NAME,
COUNT(C.CUST_CODE) CNT,
SUM(O.ORDER_AMNT) TTL_AMT,
ROUND(1.0*SUM(O.ORDER_AMNT)/COUNT(C.CUST_CODE),0) AVG_AMT
FROM 
    ORDERS O
INNER JOIN 
	CUSTOMER C ON O.CUST_CODE = C.CUST_CODE
WHERE 1=1
    AND ORDER_DATE BETWEEN "2023-09-01" AND "2023-09-30"
GROUP BY
    C.CUST_CODE
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    1.0*SUM(O.ORDER_AMNT)/COUNT(C.CUST_CODE) DESC,
    CODE ASC
) T
WHERE CNT >= 5
LIMIT 5