--受注が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
group by ORDERS.CUST_CODE
having count(*)>5
order by CNT desc,AVG_AMT desc,CODE asc;