Use Atlantic;
GO
SELECT customer_id
, (orders_qty * orders_sell_price) AS line_total,
	(SELECT CAST(AVG(orders_qty * orders_sell_price) AS DECIMAL(8,2))
	FROM Orders) AS avg_table
FROM  Orders
ORDER BY customer_id;