select
CUST_CODE as CODE
,CUST_NAME as NAME
, count(1)  as CNT
, sum(ORDER_AMNT) as TTL_AMT
, ROUND(avg(ORDER_AMNT)) as AVG_AMT
from CUSTOMER
inner join ORDERS using (CUST_CODE)
where 
ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
-- and 
GROUP BY CUST_CODE
having CNT >= 5
order by 
CNT desc
, AVG_AMT desc
, CODE
limit 5