SELECT
    CR.CUST_CODE AS CODE,
    CR.CUST_NAME AS NAME,
    COUNT(OS.CUST_CODE) AS CNT,
    SUM(OS.ORDER_AMNT) AS TTL_AMT,
    SUM(OS.ORDER_AMNT)/COUNT(OS.CUST_CODE) AS AVG_AMT
FROM
    ORDERS OS
INNER JOIN
    CUSTOMER CR
ON OS.CUST_CODE = CR.CUST_CODE
GROUP BY
    OS.CUST_CODE
HAVING
    CNT >= 5 
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC;