SELECT
    tmp.CODE
    , C.CUST_NAME AS NAME
    , tmp.CNT
    , tmp.TTL_AMT
    , tmp.AVG_AMT
FROM 
    (
    SELECT
        CUST_CODE AS CODE
        , COUNT(*) AS CNT
        , SUM(ORDER_AMNT) AS TTL_AMT
        , ROUND((SUM(ORDER_AMNT)/COUNT(*)),0) AS AVG_AMT
    FROM ORDERS
    WHERE
        ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
    GROUP BY 
        CUST_CODE
    ) AS tmp
INNER JOIN CUSTOMER AS C
    ON tmp.CODE = C.CUST_CODE
WHERE
    tmp.CNT >= 5
ORDER BY
    tmp.CNT DESC
    , tmp.AVG_AMT DESC
    , tmp.CODE
LIMIT 5;