CREATE VIEW [Product Sales for 1995] AS 
SELECT  CategoryName, ProductName, 
Sum(Round(Ord_OrdDet.UnitPrice * Quantity * (1 - Discount), 2)) AS ProductSales
FROM      (Categories 
                 INNER JOIN  
                 Products 
                 ON Categories.CategoryID = Products.CategoryID) 
            Cat_Prod 
            INNER JOIN 
                 (Orders 
                  INNER JOIN 
                  [Order Details] 
                  ON Orders.OrderID = [Order Details].OrderID) 
             Ord_OrdDet
             ON Cat_Prod.ProductID = Ord_OrdDet.ProductID
WHERE Ord_OrdDet.ShippedDate Between '1995-01-01 00:00:00' And '1995-12-31 00:00:00'
GROUP BY Cat_Prod.CategoryName, Cat_Prod.ProductName