SELECT 
	CUSTOMER.CUST_CODE as CODE,
	CUSTOMER.CUST_NAME as NAME,
	COUNT(ORDERS.CUST_CODE) as CNT,
	SUM(ORDERS.ORDER_AMNT) as TTL_AMT,
	ROUND(AVG(ORDERS.ORDER_AMNT),0) as AVG_AMT
	
FROM
    ORDERS
    
INNER JOIN CUSTOMER
        ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'


     
GROUP BY
     ORDERS.CUST_CODE
     
HAVING
    SUM(ORDERS.ORDER_AMNT) > 5

ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC;