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