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