Northwind
Basic Index
Expanded Index
View Name:
Products Above Average Price
Field
Type
Nulls?
ProductName
nvarchar (40)
No
UnitPrice
money
Yes
create view "Products Above Average Price" AS
SELECT Products.ProductName, Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)
--ORDER BY Products.UnitPrice DESC