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 as o
join  CUSTOMER as c 
on o.CUST_CODE = c.CUST_CODE
where
o.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
group by o.cust_code
having cnt > 4
order by 
CNT DESC,
AVG_AMT DESC,
CODE ASC
LIMIT 5