Question: Management is proposing to increase the price of each book. The amount of the increase will be based on each books category, according to the

Management is proposing to increase the price of each book. The amount of the increase will be based on each book’s category, according to the following scale: Computer books, 10%; Fitness books, 15%; Self-Help books, 25%; all other categories, 3%. Create a list that displays each book’s title, category, current retail price, and revised retail price. The prices should be displayed with two decimal places. The column headings for the output should be as follows: Title, Category, Current Price, and Revised Price. Sort the results by category. If there’s more than one book in a category, a secondary sort should be performed on the book’s title. Create a document to show management the SELECT statement used to generate the results and the results of the statement.

Step by Step Solution

3.32 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SELECT title Title category Category re... View full answer

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

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212912e_716610.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212912e_716610.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!