Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions

Question

7. How might you go about testing these assumptions?

Answered: 1 week ago