Northwind view

Product Sales for 1997

Native view in the Northwind sample database.

0rows

3 columns

Schema from the provider contract

Column	Type	Nullable	Key	References
`CategoryName`	`TEXT`	yes	—	—
`ProductName`	`TEXT`	yes	—	—
`ProductSales`	`TEXT`	yes	—	—

View definition

CREATE VIEW [Product Sales for 1997] AS
SELECT Categories.CategoryName, 
       Products.ProductName, 
       Sum(([Order Details].UnitPrice*Quantity*(1-Discount)/100)*100) AS ProductSales
FROM Categories
 JOIN    Products On Categories.CategoryID = Products.CategoryID
    JOIN  [Order Details] on Products.ProductID = [Order Details].ProductID     
     JOIN  [Orders] on Orders.OrderID = [Order Details].OrderID 
WHERE Orders.ShippedDate Between DATETIME('1997-01-01') And DATETIME('1997-12-31')
GROUP BY Categories.CategoryName, Products.ProductName

Data preview

Sample records

0 rows available

This recordset has no sample rows.