Question: Create and execute a query that returns the CD titles, their original unit price and then a discounted price (after 20% discount and rounded off

Create and execute a query that returns the CD titles, their original unit price and then a discounted price (after 20% discount and rounded off to 2 decimal places only) and sort the results with respect to the discounted price. [schema: om]

The query would return 10 rows as shown here

\begin{tabular}{lcc} title & unit_price & afterdiscou \\ \hline Race Car Sounds & 13.00 & 10.40 \\ Rude Noises & 13.00 & 10.40 \\ No Rest For The Weary & 16.95 & 13.56 \\ No Fixed Address & 16.95 & 13.56 \\ Zone Out With Umami & 16.95 & 13.56 \\ Etcetera & 17.00 & 13.60 \\ On The Road With Burt Ruggles & 17.50 & 14.00 \\ Umami In Concert & 17.95 & 14.36 \\ More Songs About Structures and Comestibles & 17.95 & 14.36 \\ Burt Ruggles: An Intimate Portrait & 17.95 & 14.36 \end{tabular}

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!

A selection of the expected result set has been shown below for your convenience. Your output should match with this sample output. PAY SPECIAL ATTENTION TO COLUMN NAMES. Create and execute a query...

Please, I need help with the calculations for the following 25 problems in the "final" tab of the workbook before 9pm CST. FINC 340 Quizzes 1 2 Derivatives can be strictly defined as Financial...

target walmart appendix D more information on target more information on walmart Refet to the financial statements of Target (Agpendix B) and Waimart (Apgendix C) and the Industry Ratio Report...

Can someone help with on this quiz? It has 90 minutes allotted to it, and I am willing to pay more. It is for finance 300. Profitability index. Given the discount rate and the future cash flow of...

Q This document has all of the instruction in it. please contact me if you have any questions. Download Attachment: (1) On October 5, Narveson Company buys merchandise on account from Rossi Company....

It is March 1, 2015, the first business day of the month, and you have just been hired as the accountant for Bentley Inc., which operates with monthly accounting periods. For simplicity, ignore all...

Please answer all of the question. Please! Thank you so much. Problem 6-05 Buffalo Ranch & Farm is a distributor of ranch and farm equipment. Its products include small tools, power equipment for...

Please at the end give me a excel folder link please I should take as a excel class folder Pls not as screen shots I will give you upvote if u will do it thank you IS100 ASSIGNMENT 2-Data Analysis...

Question 22 Which of the following is a current liability? A long-term debt maturing currently, which is to be paid with cash in a sinking fund A long-term debt maturing currently, which is to be...

Payton Company has the following segment revenues for the two most recent years Prior Year (in millions) (in milions) Current Year Segment United States $835 $610 Canada 335 345 Other countries 215...

FIGURE 10.1 Prices and yields of U.S. Treasury bonds, February 15, 2017 Source: The Wall Street Journal Online, April 22, 2017. Maturity Coupon Bid Ask Chg 15-Feb-2018 3.500 102.5000 102.5156 -0.0547...

1. How much is your total net annual income based on these numbers?2. What is the approximate minimum unit sales price per container of berry jam that you need to break even?3. Going back to $9.00...

Beckenworth had cost of goods sold of $ 1 0 , 6 2 1 million, ending inventory of $ 3 , 2 8 9 million, and average inventory of $ 2 , 0 8 5 million. Its days' sales in inventory equals

3. How might you apply these learnings to the challenges you face currently?

1. What will you say to Diane? Are there additional questions you would like to ask?

2. What advice will you give her? What do you think are some of the sources of her stress? How will you work with her to develop strategies for reducing her stress?