Northwind view

Order Details Extended

Native view in the Northwind sample database.

2,155rows

7 columns

Schema from the provider contract

Column	Type	Nullable	Key	References
`OrderID`	`TEXT`	yes	—	—
`ProductID`	`TEXT`	yes	—	—
`ProductName`	`TEXT`	yes	—	—
`UnitPrice`	`TEXT`	yes	—	—
`Quantity`	`TEXT`	yes	—	—
`Discount`	`TEXT`	yes	—	—
`ExtendedPrice`	`TEXT`	yes	—	—

View definition

CREATE VIEW [Order Details Extended] AS
SELECT [Order Details].OrderID, 
       [Order Details].ProductID, 
       Products.ProductName, 
	   [Order Details].UnitPrice, 
       [Order Details].Quantity, 
       [Order Details].Discount, 
      ([Order Details].UnitPrice*Quantity*(1-Discount)/100)*100 AS ExtendedPrice
FROM Products 
     JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID

Data preview

Sample records

2,155 rows available

OrderID	ProductID	ProductName	UnitPrice	Quantity	Discount	ExtendedPrice
10248	11	Queso Cabrales	14	12	0	168
10248	42	Singaporean Hokkien Fried Mee	9.8	10	0	98
10248	72	Mozzarella di Giovanni	34.8	5	0	174
10249	14	Tofu	18.6	9	0	167.4
10249	51	Manjimup Dried Apples	42.4	40	0	1696
10250	41	Jack's New England Clam Chowder	7.7	10	0	77
10250	51	Manjimup Dried Apples	42.4	35	0.15	1261.3999999999999
10250	65	Louisiana Fiery Hot Pepper Sauce	16.8	15	0.15	214.2