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