select ORDERS.CUST_CODE, CUST_NAME ,
count(1) as CNT,
sum(ORDER_AMNT) as TTL_AMT,
round(sum(ORDER_AMNT)/count(1)) 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 ORDERS.CUST_CODE, CUST_NAME 
having count(1) >= 5
order by 3 desc,5 desc, 1
limit 5
;