Northwind
Basic Index Expanded Index
| View Name: | Quarterly Orders |
| Field | Type | Nulls? | | CustomerID | nchar (5) | Yes |
| CompanyName | nvarchar (40) | Yes |
| City | nvarchar (15) | Yes |
| Country | nvarchar (15) | Yes |
create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'