Answered step by step
Verified Expert Solution
Question
1 Approved Answer
total value of product ID 7 delivered 2229.70 Display the total value for product ID 7 in the deliveries table. Note that product Id 7
total value of product ID 7 delivered | |
2229.70 |
Display the total value for product ID 7 in the deliveries table. Note that product Id 7 was delivered twice. The first one is on Oct. 11,2016-12 units of $79.99 per unit. The second one is on Oct. 12, 2016--18 units of $69.99 per unit. The displayed total value for the ProductID 7 should be 12x79.99 + 18x69.99=2219.70
Sql exercise 5.4
I have this
Select sum(quantity*price) AS "Total vaule of Product ID 7 delivered" from Sales.OrderDetails Where Sales.orderDetalis = 7
but get
The multi-part identifier "Sales.orderDetalis" could not be bound.
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