select ORDERS.CUST_CODE as 'CODE', 
CUST_NAME as 'NAME',
count(*) as 'CNT',
sum(ORDER_AMNT) as 'TTL_AMT',
round(sum(ORDER_AMNT)*1.0/count(*)) as 'AVG_AMT'
from ORDERS
inner join CUSTOMER as c on c.CUST_CODE=ORDERS.CUST_CODE
where '2023-09-01'<=ORDER_DATE
and ORDER_DATE<='2023-09-31'
group by ORDERS.CUST_CODE
having CNT>=5
order by 3 desc, 5 desc, 1 asc