Northwind › Views
Category Sales for 1997 view
8 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 | CategorySales |
(none) | no | — |
Definition
CREATE VIEW "Category Sales for 1997" AS
SELECT CategoryName, sum(ProductSales) AS CategorySales
FROM "Product Sales for 1997"
GROUP BY CategoryName