Question: Write and execute a query that lists the product ids in product id order and the total dollar value less discount per product id for

Write and execute a query that lists the product ids in product id order and the total dollar value less discount per product id for all orders in the TSQLFundamentals2008 database for products that had at least $3,044 of total discounted sales. Hint quantity, price and discount are in the order details table. Use ANSI-92 syntax for any JOINs required. Question is worth ten points. Copy your solution (SQL statement along with the result set) and paste it into the answer box.

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!

The head of marketing is interested in some opportunities for cross-selling of products. She thinks that the way to identify cross-selling opportunities is to know for each product how many other...

. The head of marketing is interested in some opportunities for cross-selling of products. She thinks that the way to identify cross-selling opportunities is to know for each product how many other...

The head of marketing is interested in some opportunities for cross-selling of products. She thinks that the way to identify cross-selling opportunities is to know for each product how many other...

COB 2 0 4 Database Project - Documentation Enter your team number here: Team 8 Enter every team member's here: Kendyl Ketchum COB 2 0 4 Company is a retail store that sells and ships goods to their...

1- Write SQL queries for the following: Find the maximum value of invoice_total and the sum of all invoice_total in the invoices table using a single query. Retrieve the invoice_id and invoice_total...

MBA 280 Fall 2017 Inventory Management Time Frame: Class 5 - Class 6 References: Operations Management Reading: Managing Inventory Simulation: Root Beer Game Played in Class 6, Oct 5th, Check Saclink...

SUFFOSTOCK Super Bakery, Inc., has been developed on the lines of a virtu- al corporation. This company, which was formed by former Pittsburgh Steelers' running back Franco Harris in 1983, is a sup-...

Question 3 (a) Compute the 2014 inventory turnover ratio and the days in inventory ratio. Note: what Groupon calls finished goods inventory is really merchandise inventory. Further, these...

Venus Candy Company budgeted the following costs for anticipated production for September 2010: Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory...

Suppose that Slovenia and Wales both produce boots and shoes. Slovenia's opportunity cost of producing a pair of shoes is 4 pairs of boots while Wales's opportunity cost of producing a pair of shoes...

Define accounting and discuss its functions.

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

7. How might you motivate managers to play a more active role in ensuring transfer of training?

6. What technologies might be useful for ensuring transfer of training? Briefly describe each technology and how it could be used.

8. Provide recommendations for how to manage knowledge.