SELECT CUST_CODE AS CODE, CUST_NAME AS NAME, COUNT(ORDER_NO) AS CNT, SUM(ORDER_AMNT) AS TTL_AMT, ROUND(SUM(ORDER_AMNT + 0.0) / COUNT(ORDER_NO)) AS AVG_AMT
FROM ORDERS JOIN CUSTOMER USING (CUST_CODE)
WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY 1 HAVING CNT >= 5 ORDER BY 3 DESC, 5 DESC, 1 LIMIT 5;