Northwind view

Quarterly Orders

Native view in the Northwind sample database.

0rows

4 columns

Schema from the provider contract

Column	Type	Nullable	Key	References
`CustomerID`	`TEXT`	yes	—	—
`CompanyName`	`TEXT`	yes	—	—
`City`	`TEXT`	yes	—	—
`Country`	`TEXT`	yes	—	—

View definition

CREATE VIEW [Quarterly Orders] AS
SELECT DISTINCT Customers.CustomerID, 
                Customers.CompanyName, 
                Customers.City, 
                Customers.Country
FROM Customers 
     JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN DATETIME('1997-01-01') And DATETIME('1997-12-31')

Data preview

Sample records

0 rows available

This recordset has no sample rows.