with delorder AS(
    select ORDER_NO,SUM(ORDER_AMNT) AS TTL_AMT,CUST_CODE,
           COUNT(*) AS CNT,ROUND(AVG(ORDER_AMNT),0) AS AVG_AMT
    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,
       TTL_AMT,
       AVG_AMT
FROM CUSTOMER JOIN delorder ON(CUSTOMER.CUST_CODE = delorder.CUST_CODE)
ORDER BY CNT DESC,AVG_AMT DESC,CODE
LIMIT 5