SELECT
 ORD.CUST_CODE AS CODE
 , CUS.CUST_NAME As NAME
 , COUNT(ORD.ORDER_NO) AS CNT
 , SUM(ORD.ORDER_AMNT) AS TTL_AMT
 , ROUND(AVG(ORD.ORDER_AMNT)) AS AVG_AMT
FROM ORDERS ORD
INNER JOIN CUSTOMER CUS
ON ORD.CUST_CODE = CUS.CUST_CODE
WHERE ORD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY ORD.CUST_CODE
having count(ord.order_no) >= 5
ORDER BY CNT DESC, AVG_AMT DESC, CODE DESC
limit 5