Northwind › Views
Summary of Sales by Quarter view
809 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 | ShippedDate |
TEXT |
no | — | ||
| 1 | OrderID |
INTEGER |
no | — | ||
| 2 | Subtotal |
(none) | no | — |
Definition
CREATE VIEW "Summary of Sales by Quarter" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL