select
    o.CUST_CODE as 'CODE'
    , c.CUST_NAME as 'NAME'
    , count(*) as 'CNT'
    , sum(ORDER_AMNT) as 'TTL_AMT'
    , round(avg(ORDER_AMNT), 0) as 'AVG_AMT'
from
    ORDERS o
    inner join CUSTOMER 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
    CNT >= 5
order by
    CNT desc
    , AVG_AMT desc
    , CODE asc
limit 5
;