Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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