Northwind › Views
Quarterly Orders view
86 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | CustomerID |
TEXT |
no | — | ||
| 1 | CompanyName |
TEXT |
no | — | ||
| 2 | City |
TEXT |
no | — | ||
| 3 | Country |
TEXT |
no | — |
Definition
CREATE VIEW "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Orders LEFT JOIN Customers ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '1997-01-01' AND '1997-12-31'