select 
    b.CUST_CODE as CODE,
    CUST_NAME as NAME,
    count(*) as CNT,
    sum(ORDER_AMNT) as TTL_AMT,
    round(avg(ORDER_AMNT)) as AVG_AMT
from (
    select *
    from ORDERS
    where date('2023-09-01') <= date(ORDER_DATE) and date(ORDER_DATE) <= date('2023-09-30')
) as b
join CUSTOMER as c on b.CUST_CODE = c.CUST_CODE
group by b.CUST_CODE
having CNT >= 5
order by CNT desc, AVG_AMT desc, CODE
limit 5;