select 
O.CUST_CODE CODE,
C.CUST_NAME NAME,
count(O.CUST_CODE) CNT,
sum(O.ORDER_AMNT) TTL_AMT,
round(AVG(O.ORDER_AMNT)) AVG_AMT

from ORDERS O inner join CUSTOMER 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 count(O.CUST_CODE) >= 5

order by 
CNT desc,
AVG_AMT desc,
CODE asc