select
    CUSTOMER.CUST_CODE CODE,
    CUST_NAME NAME,
    count(1) CNT,
    sum(ORDERS.ORDER_AMNT) TTL_AMT,
    ROUND(AVG(ORDERS.ORDER_AMNT)) AVG_AMT
from
    CUSTOMER
    join ORDERS on ORDERS.ORDER_DATE >= '2023-09-01'
    and ORDERS.ORDER_DATE <= '2023-09-30'
    and ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
group by
    code
having
    CNT >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE
limit
    5;