select
    o.cust_code "CODE"
    ,c.cust_name "NAME"
    ,count(o.cust_code) "CNT"
    ,SUM(o.ORDER_AMNT) "TTL_AMT"
    ,ROUND(AVG(o.ORDER_AMNT),0) "AVG_AMT"
from
    ORDERS o
left join customer 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, c.cust_name
having count(o.cust_code) >= 5
order by CNT desc, AVG_AMT desc, CODE asc
;