select
    OD.CUST_CODE AS CODE,
    CS.CUST_NAME AS NAME,
    COUNT(OD.ORDER_NO) AS CNT,
    SUM(OD.ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(OD.ORDER_AMNT)) AS AVG_AMT
from
    ORDERS AS OD
    INNER JOIN CUSTOMER AS CS
    ON OD.CUST_CODE = CS.CUST_CODE
    
where
    OD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'

GROUP BY
    OD.CUST_CODE
    HAVING CNT >= 5

ORDER BY 
    CNT desc,
    AVG_AMT desc,
    CODE desc

LIMIT 5;