Northwind › Views
Product Sales for 1997 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 | CategoryName |
TEXT |
no | — | ||
| 1 | ProductName |
TEXT |
no | — | ||
| 2 | ProductSales |
(none) | no | — |
Definition
CREATE VIEW "Product Sales for 1997" AS
SELECT Categories.CategoryName, Products.ProductName,
sum(round("Order Details".UnitPrice * Quantity * (1 - Discount), 2)) AS ProductSales
FROM Categories
INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
INNER JOIN "Order Details" ON Products.ProductID = "Order Details".ProductID
INNER JOIN Orders ON Orders.OrderID = "Order Details".OrderID
WHERE Orders.ShippedDate BETWEEN '1997-01-01' AND '1997-12-31'
GROUP BY Categories.CategoryName, Products.ProductName