Listing 1: GROUP BY with Summary Data
SELECT OD.ProductID AS 'Product ID'
	, sum(OD.Quantity) AS 'Total Sold'
FROM northwind.dbo.[Order Details] AS OD
GROUP BY OD.ProductID
ORDER BY OD.ProductID