SELECT CUSTOMER.CUST_CODE as CODE, CUST_NAME as NAME, count(*) as CNT, sum(ORDER_AMNT) as TTL_AMT, round(avg(ORDER_AMNT)) as AVG_AMT
FROM CUSTOMER JOIN ORDERS ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
WHERE ORDER_DATE >= '2023-09-01' AND ORDER_DATE <= '2023-09-31'
GROUP BY ORDERS.CUST_CODE
HAVING COUNT(*) >= 5
ORDER BY CNT DESC, AVG_AMT DESC, CODE ASC
LIMIT 5