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 |
|---|---|---|---|
| 1 | Beverages | Chai | 4887.0 |
| 1 | Beverages | Chang | 7038.55 |
| 1 | Beverages | Chartreuse verte | 4475.7 |
| 1 | Beverages | Côte de Blaye | 49198.090000000004 |
| 1 | Beverages | Guaraná Fantástica | 1630.13 |
| 1 | Beverages | Ipoh Coffee | 11069.9 |
| 1 | Beverages | Lakkalikööri | 7379.1 |
| 1 | Beverages | Laughing Lumberjack Lager | 910.0 |
| 1 | Beverages | Outback Lager | 5468.4 |
| 1 | Beverages | Rhönbräu Klosterbier | 4485.55 |
| 1 | Beverages | Sasquatch Ale | 2107.0 |
| 1 | Beverages | Steeleye Stout | 5274.9 |
| 2 | Condiments | Aniseed Syrup | 1724.0 |
| 2 | Condiments | Chef Anton's Cajun Seasoning | 5214.88 |
| 2 | Condiments | Chef Anton's Gumbo Mix | 373.63 |
| 2 | Condiments | Genen Shouyu | 1474.83 |
| 2 | Condiments | Grandma's Boysenberry Spread | 2500.0 |
| 2 | Condiments | Gula Malacca | 6737.95 |
| 2 | Condiments | Louisiana Fiery Hot Pepper Sauce | 9373.18 |
| 2 | Condiments | Louisiana Hot Spiced Okra | 2958.0 |
| 2 | Condiments | Northwoods Cranberry Sauce | 4260.0 |
| 2 | Condiments | Original Frankfurter grüne Soße | 4761.38 |
| 2 | Condiments | Sirop d'érable | 9091.5 |
| 2 | Condiments | Vegie-spread | 6899.26 |
| 3 | Confections | Chocolade | 1282.01 |