Execute the following Microsoft SQL Server T-SQL script in Query Analyzer or SSMS Query Editor to create views and SELECT from views:

USE Northwind;

GO

CREATE VIEW [LowPriceProducts]

AS

  SELECT ProductName,

         UnitPrice

  FROM   Products

  WHERE  UnitPrice < 1.0 / 3.0 * (SELECT AVG(UnitPrice)

                                  FROM   Products)

GO

SELECT   *

FROM     LowPriceProducts

ORDER BY ProductName

GO

/*

ProductName             UnitPrice

Filo Mix                7.00

Geitost                 2.50

Guaraná Fantástica      4.50

Konbu                   6.00

....

*/

CREATE VIEW [HighPriceProducts]

AS

  SELECT ProductName,

         UnitPrice

  FROM   Products

  WHERE  UnitPrice > 2.0 / 3.0 * (SELECT AVG(UnitPrice)

                                  FROM   Products)

GO

SELECT   *

FROM     HighPriceProducts

ORDER BY ProductName

GO

/*

ProductName                   UnitPrice

Alice Mutton                  39.00

Camembert Pierrot             34.00

Carnarvon Tigers              62.50

Chef Anton's Cajun Seasoning  22.00

....

Related article:

http://www.sqlusa.com/bestpractices2005/viewwithcte/