select CUSTOMER.CUST_CODE AS CODE, CUST_NAME AS NAME,count(ORDERS.CUST_CODE) AS CNT, 
SUM(ORDERS.ORDER_AMNT) AS TTL_AMNT,SUM(ORDERS.ORDER_AMNT)/count(ORDERS.CUST_CODE) AS AVG_AMT FROM CUSTOMER LEFT JOIN ORDERS ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE GROUP BY CUSTOMER.CUST_CODE HAVING COUNT(ORDERS.CUST_CODE) >= 5;