SELECT
OD.CUST_CODE AS CODE,
CU.CUST_NAME AS NAME,
COUNT(*) AS CNT,
SUM(OD.ORDER_AMNT) AS TTL_AMT,
ROUND(SUM(CAST(OD.ORDER_AMNT AS FLOAT))/COUNT(*)) AS AVG_AMT
FROM ORDERS AS OD
LEFT JOIN CUSTOMER AS CU
USING(CUST_CODE)
WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY OD.CUST_CODE
HAVING CNT >= 5
ORDER BY CNT DESC,AVG_AMT DESC,CODE
LIMIT 5
;