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.
| CategoryName | ProductName | ProductSales |
|---|---|---|
| Beverages | Chai | 4887.0 |
| Beverages | Chang | 7038.55 |
| Beverages | Chartreuse verte | 4475.7 |
| Beverages | Côte de Blaye | 46563.090000000004 |
| Beverages | Guaraná Fantástica | 1553.63 |
| Beverages | Ipoh Coffee | 11069.9 |
| Beverages | Lakkalikööri | 7883.1 |
| Beverages | Laughing Lumberjack Lager | 910.0 |
| Beverages | Outback Lager | 5828.4 |
| Beverages | Rhönbräu Klosterbier | 4191.05 |
| Beverages | Sasquatch Ale | 1967.0 |
| Beverages | Steeleye Stout | 5706.9 |
| Condiments | Aniseed Syrup | 1724.0 |
| Condiments | Chef Anton's Cajun Seasoning | 5214.88 |
| Condiments | Chef Anton's Gumbo Mix | 373.63 |
| Condiments | Genen Shouyu | 1474.83 |
| Condiments | Grandma's Boysenberry Spread | 2500.0 |
| Condiments | Gula Malacca | 6543.45 |
| Condiments | Louisiana Fiery Hot Pepper Sauce | 9331.08 |
| Condiments | Louisiana Hot Spiced Okra | 2958.0 |
| Condiments | Northwoods Cranberry Sauce | 4260.0 |
| Condiments | Original Frankfurter grüne Soße | 4906.98 |
| Condiments | Sirop d'érable | 9091.5 |
| Condiments | Vegie-spread | 6899.26 |
| Confections | Chocolade | 1282.01 |