--受注が6回以上の客だけ抽出
select 
 ORDERS.CUST_CODE as CODE
 ,CUSTOMER.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 date(ORDER_DATE) between '2023-09-01' and '2023-09-31'
group by CODE,NAME
having count(*)>5
order by CNT desc,AVG_AMT desc,CODE asc;