SELECT Customer.CustomerID, SUM(OrderAmt) FROM Customer INNER JOIN Orders ON Customer.CustomerID = Orders.CustomerID GROUP BY Customer.CustomerID
UNION
SELECT 'Total', SUM(OrderAmt) FROM Customer INNER JOIN Orders ON Customer.CustomerID = Orders.CustomerID