SELECT CUSTOMER.CUST_CODE as CODE, CUST_NAME as NAME, count(*) as CNT, sum(ORDER_AMNT) as TTL_AMT, avg(ORDER_AMNT) as AVG_AMT FROM CUSTOMER JOIN ORDERS ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE GROUP BY ORDERS.CUST_CODE ORDER BY CNT DESC, AVG_AMT DESC, CODE ASC