Northwind view

Sales by Category

Native view in the Northwind sample database.

0rows

4 columns

Schema from the provider contract

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

View definition

CREATE VIEW [Sales by Category] AS
SELECT Categories.CategoryID, 
       Categories.CategoryName, 
         Products.ProductName, 
	Sum([Order Details Extended].ExtendedPrice) AS ProductSales
FROM  Categories 
    JOIN Products 
      ON Categories.CategoryID = Products.CategoryID
       JOIN [Order Details Extended] 
         ON Products.ProductID = [Order Details Extended].ProductID                
           JOIN Orders 
             ON Orders.OrderID = [Order Details Extended].OrderID 
WHERE Orders.OrderDate BETWEEN DATETIME('1997-01-01') And DATETIME('1997-12-31')
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName

Data preview

Sample records

0 rows available

This recordset has no sample rows.