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.
| CategoryID | CategoryName | ProductName | ProductSales |
|---|---|---|---|
| 3 | Confections | Gumbär Gummibärchen | 10443.07 |
| 3 | Confections | Maxilaku | 3128.6 |
| 3 | Confections | NuNuCa Nuß-Nougat-Creme | 1692.6 |
| 3 | Confections | Pavlova | 8663.42 |
| 3 | Confections | Schoggi Schokolade | 10974.0 |
| 3 | Confections | Scottish Longbreads | 4157.5 |
| 3 | Confections | Sir Rodney's Marmalade | 7314.3 |
| 3 | Confections | Sir Rodney's Scones | 5273.0 |
| 3 | Confections | Tarte au sucre | 21638.31 |
| 3 | Confections | Teatime Chocolate Biscuits | 2986.75 |
| 3 | Confections | Valkoinen suklaa | 2173.44 |
| 3 | Confections | Zaanse koeken | 2930.75 |
| 4 | Dairy Products | Camembert Pierrot | 20505.4 |
| 4 | Dairy Products | Flotemysost | 8438.76 |
| 4 | Dairy Products | Geitost | 786.0 |
| 4 | Dairy Products | Gorgonzola Telino | 7300.76 |
| 4 | Dairy Products | Gudbrandsdalsost | 13062.6 |
| 4 | Dairy Products | Mascarpone Fabioli | 2668.8 |
| 4 | Dairy Products | Mozzarella di Giovanni | 11602.8 |
| 4 | Dairy Products | Queso Cabrales | 6911.94 |
| 4 | Dairy Products | Queso Manchego La Pastora | 8335.3 |
| 4 | Dairy Products | Raclette Courdavault | 35775.3 |
| 5 | Grains/Cereals | Filo Mix | 2124.15 |
| 5 | Grains/Cereals | Gnocchi di nonna Alice | 32604.0 |
| 5 | Grains/Cereals | Gustaf's Knäckebröd | 4233.6 |