select CODE, NAME, CNT, TTL_AMT, AVG_AMT
from (
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
inner 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, DATE(ORDER_DATE,'yyyymm')
)
where CNT >= 5
order by CNT desc, AVG_AMT desc, CODE
LIMIT 5