NORTHWIND: The Order Details Discount field contains fractional values such as 0.02, 0.05 but also zeros and these value

[answerhappygod]

NORTHWIND: The Order Details Discount field contains fractional
values such as 0.02, 0.05 but also zeros and these values represent
a percentage discount off of the total order amount. E.g., 0.02
represents a 2% discount. List all of the products sold in May 2015
and for each sale the total value of the discount. Total value is
the money NorthWind did not collect because of the discount
compared to what full price revenue would have been.

Northwind The Order Details Discount Field Contains Fractional Values Such As 0 02 0 05 But Also Zeros And These Value 1 (201.49 KiB) Viewed 40 times

Condensed... Employee Territories Column Name Condensed T... EmployeeID TerritoryID nvarchar(20) int int Order Details Column ... Conde... Order ID int ProductID int UnitPrice money Quantity smalint Discount nchar(s) bo Products Column Name Condensed... ProductID int ProductName nvarchar(40) Supplier ID int CategoryID int QuantityPerUnit nvarchar(20) UnitPrice money . UnitsInStock smallint inition UnitsOnOrder smallint ReorderLevel smallint Discontinued bit int real Orders Column Name OrderID Customer ID Employee Order Date RequiredDate ShippedDate Shipvia Freight ShipName ShipAddress Ship City ShipRegion ShipPostalCode ShipCountry datetime datetime datetime Int Customers Column Name Condensed... 8 Customer ID 7 nchar(5) Company Name nvarchar(40) ContactName nvarchar(30) Contact Title nvarchar(30) Address nvarchar(60) Oty nvarchar(15) Region nvarchar(15) PostalCode nvarchar(10) Country Darchulas nvarchar(15) Phone nvarchar(24) Fax nvarchar(24) Categories Column Name Condensed... CategoryID int CategoryName nvarchar(15) ntext money nvarchar(40) nvarchar(60) ) nvarchar(15) nvarchar(15) nvarchar(10) nvarchar(15) - DOC Description Picture image CustomerCustomerDemo Column Name Condensed T... 8 Customer ID nchar(5) Customer.. nchar(10) Suppliers Column Name Condensed... 7 SupplierID int CompanyName nvarchar(40) ContactName nvarchar(30) Contact Title nvarchar(30) nvarchar(60) City nvarchar(15) Region nvarchar(15) Postal Code nvarchar(10) Country nvarchar(15) Phone nvarchar (24) Fax nvarchar(24) HomePage ntext Territories Column Name Condensed... TerritoryID nvarchar(20) TerritoryDescription nchar(50) RegionID int Address Employees Column Name Condensed ... 3 Employee int LastName nvarchar(20) FirstName nvarchar(10) Title nvarchar(30) TitleOfCourtesy nvarchar(25) BirthDate datetime HireDate datetime Address nvarchar(60) City nvarchar(15) Region nvarchar(15) Postal Code nvarchar(10) Country nvarchar(15) Home Phone nvarchar(24) Extension nvarchar(4) Photo image Notes ntext Reports To int PhotoPath nvarchar(255) Shippers Column Name Condensed... 8 8 ShipperID int Company Name nvarchar(40) Phone nvarchar(24) Customer Demographics Column Name Conden... Customer TypeID nchar(10) Customer Desc ntext Region Column Name Conden... 8 RegionID int RegionDescription nchar(50)