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