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
SELECT title Title category Category re... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c1212912e_716610.pdf
180 KBs PDF File
1803_60b8c1212912e_716610.docx
120 KBs Word File
