Question
In the WorldWideImporters database's [Purchasing].[PurchaseOrderLines] table the [OrderedOuters] indicates the number of items the customer wants. [ReceivedOuters] is the number of items being shipped to
In the WorldWideImporters database's [Purchasing].[PurchaseOrderLines] table the [OrderedOuters] indicates the number of items the customer wants. [ReceivedOuters] is the number of items being shipped to the customer. If the received is less than the ordered, the warehouse is short items and the missing items will be shipped later when they arrive. [ExpectedUnitPricePerOuter] is the price the customer will be charged per [ReceivedOuters].
Calculate the total order cost to the customer of purchaseOrderID 12. Ensure that the customer is only paying for items shipped. Display this single value result set with 2 decimal places precision.
Use SSMS and paste your SQL here
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999
Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla
2010th Edition
