Northwind › Views
Sales by Category view
77 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | CategoryID |
INTEGER |
no | — | ||
| 1 | CategoryName |
TEXT |
no | — | ||
| 2 | ProductName |
TEXT |
no | — | ||
| 3 | ProductSales |
(none) | no | — |
Definition
CREATE VIEW "Sales by Category" AS
SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName,
sum("Order Details Extended".ExtendedPrice) AS ProductSales
FROM Categories
INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
INNER JOIN "Order Details Extended" ON Products.ProductID = "Order Details Extended".ProductID
INNER JOIN Orders ON Orders.OrderID = "Order Details Extended".OrderID
WHERE Orders.OrderDate BETWEEN '1997-01-01' AND '1997-12-31'
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName