Northwind view

Sales Totals by Amount

Native view in the Northwind sample database.

0rows

4 columns

Schema from the provider contract

Column	Type	Nullable	Key	References
`SaleAmount`	`TEXT`	yes	—	—
`OrderID`	`TEXT`	yes	—	—
`CompanyName`	`TEXT`	yes	—	—
`ShippedDate`	`TEXT`	yes	—	—

View definition

CREATE VIEW [Sales Totals by Amount] AS
SELECT [Order Subtotals].Subtotal AS SaleAmount, 
                  Orders.OrderID, 
               Customers.CompanyName, 
                  Orders.ShippedDate
FROM Customers 
 JOIN Orders ON Customers.CustomerID = Orders.CustomerID
    JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID 
WHERE ([Order Subtotals].Subtotal >2500) 
AND (Orders.ShippedDate BETWEEN DATETIME('1997-01-01') And DATETIME('1997-12-31'))

Data preview

Sample records

0 rows available

This recordset has no sample rows.