Wrapping SELECTs in Views

In some cases, it makes sense to wrap a frequently used query in a view, as shown in Listing 6-12.

Listing 6.12. Wrapping a query inside a view.

CREATE VIEW dbo.TotalSalesByState
AS
SELECT SUM(Amount) AS TotalSales, StateCode
FROM dbo.Sales
GROUP BY StateCode ;