SELECT
    OD.CUST_CODE as CODE
    , CS.CUST_NAME as NAME
    , COUNT(OD.ORDER_NO) as CNT
    , SUM(OD.ORDER_AMNT) as TTL_AMT
    , ROUND(AVG(OD.ORDER_AMNT)) as AVG_AMT
FROM
    ORDERS as OD
    INNER JOIN CUSTOMER as CS
        ON CS.CUST_CODE = OD.CUST_CODE
WHERE
    OD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
    OD.CUST_CODE
    --, CS.CUST_NAME

HAVING
    CNT >= 5 
ORDER BY
    CNT DESC
    , AVG_AMT DESC
    , CODE ASC
LIMIT 5;