Question: Northwind databse sql Problem Problem 7 : Get the total product costs ( i . e . , multiplying the unit price by quantity )

Northwind databse sql Problem Problem 7: Get the total product costs (i.e., multiplying the unit price by quantity) for ProductID =20 along with the associated orders IDs from the OrderDetails table. Provide the results in ascending order based on the order ID.
Expected Output
The expected query output showing the total product costs for ProductID =20 along with the associated order IDs from the OrderDetails table.
Problem 8: Select all of the cities where there are employees with no duplicates values displayed. Show the cities in alphabetical order.
Expected Output
The expected query output showing all cities where there are employees with no duplicate values displayed.
Problem 9: List first and last names for employees who live in London, Seattle, or Redmond. Show the employees city in the output.
Expected Output
The expected query output listing first and last names for employees living in London, Seattle, or Redmond
Problem 10: Display all product IDs and names for out-of-stock products having a unit price in the range of $20 to $25. Show the units-in-stock value in the results.
Expected Output
The expected query output displaying all product IDs, names, unit prices, and units-in-stock values for out-of-stock products having a unit price in the range of $20 to $25.

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!