WITH temp AS(
    SELECT DISTINCT
        CUST_CODE AS CODE
        , CUST_NAME AS NAME
        , COUNT() OVER (PARTITION BY CUST_CODE) AS CNT
        , SUM(ORDER_AMNT) OVER (PARTITION BY CUST_CODE) AS TTL_AMT
        , ROUND(AVG(ORDER_AMNT) OVER (PARTITION BY CUST_CODE)) AS AVG_AMT
    FROM
        ORDERS
        LEFT OUTER JOIN CUSTOMER USING(CUST_CODE)
    WHERE
        ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
)
SELECT
    CODE
    , NAME
    , CNT
    , TTL_AMT
    , AVG_AMT
FROM
    temp
WHERE
     CNT >= 5
ORDER BY 3 DESC, 5 DESC, 1
LIMIT 5;