Northwind
Basic Index Expanded Index
| View Name: | Category Sales for 1997 |
| Field | Type | Nulls? | | CategoryName | nvarchar (15) | No |
| CategorySales | money | Yes |
create view "Category Sales for 1997" AS
SELECT "Product Sales for 1997".CategoryName, Sum("Product Sales for 1997".ProductSales) AS CategorySales
FROM "Product Sales for 1997"
GROUP BY "Product Sales for 1997".CategoryName