SELECT
    c.CUST_CODE CODE,
    c.CUST_NAME NAME,
    COUNT(*) CNT,
    SUM(ORDER_AMNT) TTL_AMT,
    round(AVG(ORDER_AMNT),0) AVG_AMT
    FROM ORDERS o
    inner join 
    CUSTOMER c
    on o.CUST_CODE=c.CUST_CODE
    where
    ORDER_DATE >= '2023-09-01'
    AND
    ORDER_DATE <= '2023-09-30'
    group by 
    1,2
    having CNT >= 5
    order by CNT desc, AVG_AMT desc, CODE asc
    limit 5;