select 
  c.cust_code CODE,
  c.cust_name NAME,
  count(0) CNT,
  sum(o.order_amnt) TTL_AMT,
  cast(avg(o.order_amnt) + 0.5 as int) AVG_AMT
from ORDERS o
left join CUSTOMER c
on o.cust_code = c.cust_code
where ORDER_DATE >= "2023-09-01" and ORDER_DATE <= "2023-09-30"
group by 1
order by CNT desc, AVG_AMT desc, CODE
limit 5