SELECT
    CUST.CUST_CODE AS CODE,
    CUST.CUST_NAME AS NAME,
    COUNT(CUST.CUST_CODE) AS CNT,
    SUM(ORD.ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(ORD.ORDER_AMNT)) AS ABG_AMT

FROM
    CUSTOMER CUST
    INNER JOIN ORDERS ORD
    ON ORD.CUST_CODE = CUST.CUST_CODE
WHERE
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
    CUST.CUST_CODE
HAVING
    COUNT(CUST.CUST_CODE) >= 5
ORDER BY
    CNT DESC,
   ABG_AMT DESC,
    CODE
LIMIT 
   5;