SELECT 
ORDERS.CUST_CODE AS CODE,
CUSTOMER.CUST_NAME AS NAME,
COUNT(ORDERS.ORDER_AMNT) AS CNT,
SUM(ORDERS.ORDER_AMNT) AS TTL_AMT,
ROUND(AVG(ORDERS.ORDER_AMNT),1) AS AVG_AMT
FROM ORDERS 
 INNER JOIN CUSTOMER
 ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE ORDERS.ORDER_DATE BETWEEN "2023-09-01" AND "2023-09-30"
GROUP BY ORDERS.CUST_CODE
HAVING COUNT(ORDERS.ORDER_AMNT) > 4
ORDER BY CNT DESC, AVG_AMT DESC, CODE ASC
LIMIT 5;