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