SELECT o.CUST_CODE AS CODE
        ,CUST_NAME AS NAME
        ,COUNT(ORDER_NO) AS CNT
        ,SUM(ORDER_AMNT) AS TTL_AMT
        ,ROUND(AVG(ORDER_AMNT)) AS AVG_AMT
        
FROM ORDERS o JOIN CUSTOMER c
    ON o.CUST_CODE = c.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY o.CUST_CODE
    HAVING CNT >= 5 
ORDER BY CNT DESC,AVG_AMT DESC,CODE
limit 5;