Listing 1: Code That Returns Top 10 Products Based on Sum of Sales
CREATE VIEW dbo.Top10ProductSales
AS
SELECT TOP 10 OD.ProductID, sum(OD.quantity) AS Total
FROM northwind.dbo.[order details] AS OD
GROUP BY OD.ProductID
ORDER BY Total DESC
go