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