SELECT CUSTOMER.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 CUSTOMER JOIN ORDERS ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
GROUP BY ORDERS.CUST_CODE
HAVING COUNT(*) >= 5
ORDER BY CNT DESC, AVG_AMT DESC, CODE ASC