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