SELECT O.CUST_CODE AS CODE,
C.CUST_NAME AS NAME,
COUNT(O.ORDER_NO) AS CNT,
SUM(O.ORDER_AMNT) AS TTL_AMT,
ROUND(AVG(O.ORDER_AMNT),0) AS AVG_AMT

FROM ORDERS AS O
INNER JOIN CUSTOMER AS C
 ON O.CUST_CODE =C.CUST_CODE
WHERE (O.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 ASC
LIMIT 5;