Write a query to extract the fields highlighted in the ERD below. The query should have a single row per SalesOrderDetail line
Create a field to contain Price Discount. If ListPrice = 0 then PriceDiscount = 1000 (1000 in discount field is a dummy value to make these rows visible and out of the way). Otherwise Dsicount Ratio = (UnitPrice - ListPrice) / ListPrice.
Store (Sales) BusinessEntitylD Name Customer (Sales) Demographics Modified Date Person (Person) BusinessEntitylo PersenType Title SalesPerson (Sales) SalesorderHeader (Sales) Bonus Suffix ShipDate Status Salest astYear rowguic ModifiedDate ModifiedOate PurchaseOrerNumber SalesPennD TerritorMD SalesTerritory (Sales) BusinessEntity(Person) TerritorylO owguic ShipToAclcdressID ShipMethodID CreditCardID CreditCardApprovalCode CountryRegion Code (Groupl SalesLastYear CountryRegion (Person) CountryRegioncode Name CostlastYear T xArnt Freight Total Due Comment SalesReason (Sales) SalesReasonID SalesOrderHeaderSalesReason (Sales) ReasonType MoclifiedDate ModitiediDate SalesOrderDetail (Sales) SpecialOfferProduct (Sales) Product (Production) ProductID ProductiD CarrierTrackingNumber MakeFlag ModifieddDate SpecialOfferlO Color SafetyStockLeve UnitPriceDisco SpecialOffer (Sales) SpecialOfferid Description DiscountPct Typu Category rowguicl Weight DaysToManufacture ProductLine Class Style ProductModel (Production) Min Qty Max@ty ProductModelID ModifiedDate ProductModellD SellEndDate ProductCategory (Production) ProductSubcategory (Production) ModifiedDate MoclifieclDate Store (Sales) BusinessEntitylD Name Customer (Sales) Demographics Modified Date Person (Person) BusinessEntitylo PersenType Title SalesPerson (Sales) SalesorderHeader (Sales) Bonus Suffix ShipDate Status Salest astYear rowguic ModifiedDate ModifiedOate PurchaseOrerNumber SalesPennD TerritorMD SalesTerritory (Sales) BusinessEntity(Person) TerritorylO owguic ShipToAclcdressID ShipMethodID CreditCardID CreditCardApprovalCode CountryRegion Code (Groupl SalesLastYear CountryRegion (Person) CountryRegioncode Name CostlastYear T xArnt Freight Total Due Comment SalesReason (Sales) SalesReasonID SalesOrderHeaderSalesReason (Sales) ReasonType MoclifiedDate ModitiediDate SalesOrderDetail (Sales) SpecialOfferProduct (Sales) Product (Production) ProductID ProductiD CarrierTrackingNumber MakeFlag ModifieddDate SpecialOfferlO Color SafetyStockLeve UnitPriceDisco SpecialOffer (Sales) SpecialOfferid Description DiscountPct Typu Category rowguicl Weight DaysToManufacture ProductLine Class Style ProductModel (Production) Min Qty Max@ty ProductModelID ModifiedDate ProductModellD SellEndDate ProductCategory (Production) ProductSubcategory (Production) ModifiedDate MoclifieclDate
