Northwind › Views
Alphabetical list of products view
69 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued | CategoryName |
|---|---|---|---|---|---|---|---|---|---|---|
| 32 | Mascarpone Fabioli | 14 | 4 | 24 - 200 g pkgs. | 32.0 | 9 | 40 | 25 | 0 | Dairy Products |
| 33 | Geitost | 15 | 4 | 500 g | 2.5 | 112 | 0 | 20 | 0 | Dairy Products |
| 34 | Sasquatch Ale | 16 | 1 | 24 - 12 oz bottles | 14.0 | 111 | 0 | 15 | 0 | Beverages |
| 35 | Steeleye Stout | 16 | 1 | 24 - 12 oz bottles | 18.0 | 20 | 0 | 15 | 0 | Beverages |
| 36 | Inlagd Sill | 17 | 8 | 24 - 250 g jars | 19.0 | 112 | 0 | 20 | 0 | Seafood |
| 37 | Gravad lax | 17 | 8 | 12 - 500 g pkgs. | 26.0 | 11 | 50 | 25 | 0 | Seafood |
| 38 | Côte de Blaye | 18 | 1 | 12 - 75 cl bottles | 263.5 | 17 | 0 | 15 | 0 | Beverages |
| 39 | Chartreuse verte | 18 | 1 | 750 cc per bottle | 18.0 | 69 | 0 | 5 | 0 | Beverages |
| 40 | Boston Crab Meat | 19 | 8 | 24 - 4 oz tins | 18.4 | 123 | 0 | 30 | 0 | Seafood |
| 41 | Jack's New England Clam Chowder | 19 | 8 | 12 - 12 oz cans | 9.65 | 85 | 0 | 10 | 0 | Seafood |
| 43 | Ipoh Coffee | 20 | 1 | 16 - 500 g tins | 46.0 | 17 | 10 | 25 | 0 | Beverages |
| 44 | Gula Malacca | 20 | 2 | 20 - 2 kg bags | 19.45 | 27 | 0 | 15 | 0 | Condiments |
| 45 | Rogede sild | 21 | 8 | 1k pkg. | 9.5 | 5 | 70 | 15 | 0 | Seafood |
| 46 | Spegesild | 21 | 8 | 4 - 450 g glasses | 12.0 | 95 | 0 | 0 | 0 | Seafood |
| 47 | Zaanse koeken | 22 | 3 | 10 - 4 oz boxes | 9.5 | 36 | 0 | 0 | 0 | Confections |
| 48 | Chocolade | 22 | 3 | 10 pkgs. | 12.75 | 15 | 70 | 25 | 0 | Confections |
| 49 | Maxilaku | 23 | 3 | 24 - 50 g pkgs. | 20.0 | 10 | 60 | 15 | 0 | Confections |
| 50 | Valkoinen suklaa | 23 | 3 | 12 - 100 g bars | 16.25 | 65 | 0 | 30 | 0 | Confections |
| 51 | Manjimup Dried Apples | 24 | 7 | 50 - 300 g pkgs. | 53.0 | 20 | 0 | 10 | 0 | Produce |
| 52 | Filo Mix | 24 | 5 | 16 - 2 kg boxes | 7.0 | 38 | 0 | 25 | 0 | Grains/Cereals |
| 54 | Tourtière | 25 | 6 | 16 pies | 7.45 | 21 | 0 | 10 | 0 | Meat/Poultry |
| 55 | Pâté chinois | 25 | 6 | 24 boxes x 2 pies | 24.0 | 115 | 0 | 20 | 0 | Meat/Poultry |
| 56 | Gnocchi di nonna Alice | 26 | 5 | 24 - 250 g pkgs. | 38.0 | 21 | 10 | 30 | 0 | Grains/Cereals |
| 57 | Ravioli Angelo | 26 | 5 | 24 - 250 g pkgs. | 19.5 | 36 | 0 | 20 | 0 | Grains/Cereals |
| 58 | Escargots de Bourgogne | 27 | 8 | 24 pieces | 13.25 | 62 | 0 | 20 | 0 | Seafood |