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