Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 hereimage text in transcribed

\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

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

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Databases questions

Question

How is the education level required for a position established?

Answered: 1 week ago

Question

2. (1 point) Given AABC, tan A b b

Answered: 1 week ago