← All tables and views
Northwind view
Products Above Average Price
Native view in the Northwind sample database.
25rows
2 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ProductName | TEXT | yes | — | — |
UnitPrice | TEXT | yes | — | — |
View definition
CREATE VIEW [Products Above Average Price] AS
SELECT Products.ProductName,
Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)Data preview
Sample records
| ProductName | UnitPrice |
|---|---|
| Uncle Bob's Organic Dried Pears | 30 |
| Northwoods Cranberry Sauce | 40 |
| Mishi Kobe Niku | 97 |
| Ikura | 31 |
| Queso Manchego La Pastora | 38 |
| Alice Mutton | 39 |
| Carnarvon Tigers | 62.5 |
| Sir Rodney's Marmalade | 81 |