WITH target_CUST AS(
SELECT CUST_CODE, COUNT(*)
FROM ORDERS
GROUP BY CUST_CODE
HAVING COUNT(*) >5
)


SELECT 
O.CUST_CODE AS CODE
,CUST_NAME AS NAME
,count(O.CUST_CODE) as CNT
,SUM(O.ORDER_AMNT) as TTL_AMT
,ROUND(AVG(O.ORDER_AMNT)) as AVG_AMT
FROM  ORDERS O LEFT JOIN CUSTOMER C ON O.CUST_CODE = C.CUST_CODE
WHERE O.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-31'
ORDER BY
    CNT desc
    ,AVG_AMT desc
    ,CODE