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