Northwind
Basic Index Expanded Index
| View Name: | Sales Totals by Amount |
| Field | Type | Nulls? | | SaleAmount | money | Yes |
| OrderID | int | No |
| CompanyName | nvarchar (40) | No |
| ShippedDate | datetime | Yes |
create view "Sales Totals by Amount" AS
SELECT "Order Subtotals".Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName, Orders.ShippedDate
FROM Customers INNER JOIN
(Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID)
ON Customers.CustomerID = Orders.CustomerID
WHERE ("Order Subtotals".Subtotal >2500) AND (Orders.ShippedDate BETWEEN '19970101' And '19971231')