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