select
    o.CUST_CODE as CODE,
    c.CUST_NAME as NAME,
    COUNT(o.CUST_CODE) as CNT,
    SUM(o.ORDER_AMNT) as TTL_AMT,
    ROUND(AVG(o.ORDER_AMNT)) as AVG_AMT
from ORDERS as o
inner join CUSTOMER as c
on o.CUST_CODE = c.CUST_CODE
where ORDER_DATE between "2023-09-01" and "2023-09-30"
group by o.CUST_CODE
having COUNT(o.CUST_CODE) >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE
limit 5;