CREATE VIEW [Top Ten Selling Products]
AS
SELECT TOP 10 C.CategoryName, P.ProductName, SUM (
CONVERT ( money, ( OD.UnitPrice*Quantity* ( 1-Discount ) /100 ) ) *100 )
AS TotalSales
FROM Categories C, Products P, [Order Details] OD
WHERE P.CategoryId = C.CategoryID AND P.ProductId = OD.ProductID
GROUP BY C.CategoryName, P.ProductName
ORDER BY TotalSales DESC