SELECT 
    ORDERS.CUST_CODE AS CODE
,   CUSTOMER.CUST_NAME AS NAME
,   COUNT(*) AS CNT
,   SUM(ORDER_AMNT) AS TTL_AMT
,   ROUND(SUM(ORDER_AMNT) / COUNT(*), 1) AS AVG_AMT
FROM 
    ORDERS
JOIN
    CUSTOMER
ON
    ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
GROUP BY
    ORDERS.CUST_CODE
ORDER BY
    CNT DESC
,   AVG_AMT DESC
,   CODE ASC
LIMIT
    5;