SELECT
     C.CUST_CODE  AS CODE
    ,C.CUST_NAME AS NAME
    ,COUNT(O.ORDER_NO) CNT
    ,SUM(ORDER_AMNT)+SUM(CMP_TAX) TTL_AMT
    ,(SUM(ORDER_AMNT)+SUM(CMP_TAX))/COUNT(O.ORDER_NO)  AS AVG_AMT
FROM ORDERS O
INNER JOIN CUSTOMER C
ON O.CUST_CODE = C.CUST_CODE
GROUP BY O.CUST_CODE