with delorder AS(
    select ORDER_NO,ORDER_AMNT,CUST_CODE,COUNT(*) AS CNT
    FROM ORDERS
    WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-10-01'
    GROUP BY CUST_CODE
    HAVING COUNT(*) >= 5
)


SELECT DISTINCT CUSTOMER.CUST_CODE AS CODE , CUSTOMER.CUST_NAME AS NAME ,
       CNT,
       SUM(ORDER_AMNT)OVER(PARTITION BY CUSTOMER.CUST_CODE) AS TTL_AMT,
       round(AVG(ORDER_AMNT)OVER(PARTITION BY CUSTOMER.CUST_CODE),0) AS AVG_AMT
FROM CUSTOMER JOIN delorder ON(CUSTOMER.CUST_CODE = delorder.CUST_CODE)
ORDER BY CNT DESC,AVG_AMT DESC,CODE
LIMIT 5