Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need to create an SQL query using the AdventureWorks Database. Posted below are the instructions, and table structure for the database. Any assistance is appreciated. Thank You Write a query to...

Provide the SQL queries necessary to produce the information requested or to make the modifications requested. Provide only the queries you used; I do not want the query results. . All of the...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Background You serve as a data analyst for IntegrateCo, a company that installs and services integrated building management systems in the Intermountain West of the United States of America. Building...

inputs.txt: Konya Bursa Ankara A1 B1 C1 A2 B2 C2 4 print reserve_seat Ahmet Konya A1 0 reserve_seat Kamer Bursa A1 1 reserve_seat Cemal Ankara A1 2 reserve_seat Elif Konya B1 2 reserve_seat Mehmet...

This project is designed to touch all aspects of the fundamental concepts of database design and logical/physical data modeling covered in chapters 5 and 6. You are responsible for designing,...

a . Draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies.b . Remove all partial dependencies, and draw the new dependency diagrams. Identify...

LAB OVERVIEW Lab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. This lab will also introduce the fundamentals of...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Identify the cash flows available to an investor in stock. How reliably can these cash flows be estimated? Compare the problem of estimating stock cash flows to estimating bond cash flows. Which...

What are the client responsibilities that are relevant to the auditor? How do those responsibilities affect the audit opinion formulation process?

1 0 Which of the following is not usually accounted for retrospectively? Multiple Choice 0 4 : 1 9 : 0 7 Change in the composition of firms reporting on a consolidated basis. Change from LIFO to...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Continue until everyone is satisfied that his or her own needs and interests have been stated clearly; then ask the group to generate new proposals that seek to incorporate a broader range of...

2. Why has the conflict escalated?

3. What role will you play with the constituents of both groups to satisfy their requests?