select
ORDERS.CUST_CODE as CODE
, CUST_NAME as NAME
, COUNT(1) as CNT
, SUM(ORDER_AMNT) as TTL_AMT
, AVG(ORDER_AMNT) as AVG_AMT
from ORDERS join CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
group by CODE, CUST_NAME
having CNT >= 5
order by CNT desc, AVG_AMT desc, CODE
limit 5