Oracle 12c 3rd edition Chapter 10 Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database 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 following scale Computer books, 10 Fitness books, 15 Self Help books, 25 all other categories, 3 Create a list that displays each books 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 theres more than one book in a category, a secondary sort should be performed on the books title Create a document to show management the SELECT statement used to generate the results and the results of the statement Please type answer in SQL BOOKS table ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY 1059831198 BODYBUILD IN 10 MINUTES A DAY 21 JAN 05 4 18 75 30 95 FITNESS 0401140733 REVENGE OF MICKEY 14 DEC 05 1 14 2 22 FAMILY LIFE 4981341710 BUILDING A CAR WITH TOOTHPICKS 18 MAR 06 2 37 8 59 95 3 CHILDREN 8843172113 DATABASE IMPLEMENTATION 04 JUN 03 3 31 4 55 95 COMPUTER 3437212490 COOKING WITH MUSHROOMS 28 FEB 04 4 12 5 19 95 COOKING 3957136468 HOLY GRAIL OF ORACLE 31 DEC 05 3 47 25 75 95 3 8 COMPUTER 1915762492 HANDCRANKED COMPUTERS 21 JAN 05 3 21 8 25 COMPUTER 9959789321 E BUSINESS THE EASY WAY 01 MAR 06 2 37 9 54 5 COMPUTER 2491748320 PAINLESS CHILD REARING 17 JUL 04 5 48 89 95 4 5 FAMILY LIFE 0299282519 THE WOK WAY TO COOK 11 SEP 04 4 19 28 75 COOKING 8117949391 BIG BEAR AND LITTLE DOVE 08 NOV 05 5 5 32 8 95 CHILDREN 0132149871 HOW TO GET FASTER PIZZA 11 NOV 06 4 17 85 29 95 1 5 SELF HELP 9247381001 HOW TO MANAGE THE MANAGER 09 MAY 03 1 15 4 31 95 BUSINESS 2147428890 SHORTEST POEMS 01 MAY 05 5 21 85 39 95 LITERATURE

The Answer is in the image, click to view ...

Question: Oracle 12c 3rd edition Chapter 10 Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database. Management is proposing to

Oracle 12c 3rd edition

Chapter 10 Advanced Challenge

To perform this activity, refer to the tables in the JustLee Books database. 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 following scale: Computer books, 10%; Fitness books, 15%; Self-Help books, 25%; all other categories, 3%. Create a list that displays each books 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 theres more than one book in a category, a secondary sort should be performed on the books title. Create a document to show management the SELECT statement used to generate the results and the results of the statement.

Please type answer in SQL

BOOKS table
ISBN	TITLE	PUBDATE	PUBID	COST	RETAIL	DISCOUNT	CATEGORY
1059831198	BODYBUILD IN 10 MINUTES A DAY	21-JAN-05	4	18.75	30.95	-	FITNESS
0401140733	REVENGE OF MICKEY	14-DEC-05	1	14.2	22	-	FAMILY LIFE
4981341710	BUILDING A CAR WITH TOOTHPICKS	18-MAR-06	2	37.8	59.95	3	CHILDREN
8843172113	DATABASE IMPLEMENTATION	04-JUN-03	3	31.4	55.95	-	COMPUTER
3437212490	COOKING WITH MUSHROOMS	28-FEB-04	4	12.5	19.95	-	COOKING
3957136468	HOLY GRAIL OF ORACLE	31-DEC-05	3	47.25	75.95	3.8	COMPUTER
1915762492	HANDCRANKED COMPUTERS	21-JAN-05	3	21.8	25	-	COMPUTER
9959789321	E-BUSINESS THE EASY WAY	01-MAR-06	2	37.9	54.5	-	COMPUTER
2491748320	PAINLESS CHILD-REARING	17-JUL-04	5	48	89.95	4.5	FAMILY LIFE
0299282519	THE WOK WAY TO COOK	11-SEP-04	4	19	28.75	-	COOKING
8117949391	BIG BEAR AND LITTLE DOVE	08-NOV-05	5	5.32	8.95	-	CHILDREN
0132149871	HOW TO GET FASTER PIZZA	11-NOV-06	4	17.85	29.95	1.5	SELF HELP
9247381001	HOW TO MANAGE THE MANAGER	09-MAY-03	1	15.4	31.95	-	BUSINESS
2147428890	SHORTEST POEMS	01-MAY-05	5	21.85	39.95	-	LITERATURE

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!

Oracle 12c Joan Casteel ISBN ending in 51038 Chapter 10 Advanced Challenge. To perform this activity, refer to the tables in the Justlee Books database. Management is proposing to increase the price...

Oracle 12c 3rd edition Chapter 12 Advanced Challenge numbers 1 and 2 Currently, JustLee Books bills customers for orders by enclosing an invoice with each order when its shipped. A customer then has...

Here is the script given: Looking for the answer to the advanced challenge question pictured. CREATE TABLE suppliers (sup_name VARCHAR2(20), description VARCHAR2(100) ); INSERT INTO suppliers VALUES...

Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database. Management is proposing to increase the price of each book. The amount of the increase will be based on...

Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database. Currently, JustLee Books bills customers for orders by enclosing an invoice with each order when it s...

Normalization Advanced Challenge To perform this activity, refer to the table structures in above figure and the table listings in SQL Developer. In this chapter, the normalization process was shown...

Here is the script given: Looking for the answer to the Advanced Challenge Quetion. CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston');...

just need the advanced challenge portion. L Llns to perform the ftollowing actions, using the Justlee Books user account. The account name should be a combination otf your first initial es to the new...

Oracle 12c Ch 9 Advance Challenge CREATE TABLE Warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston'); INSERT INTO warehouses VALUES (20, 'Norfolk'); INSERT...

The following transactions pertain to the operations of Fleming Company for 2012. 1. Acquired $40,000 cash from the issue of common stock. 2. Performed services for $12,000 cash. 3. Provided $55,000...

Consider again the conditions of Exercise 10. Suppose also that in a random sample of size n = 10, it is found that n = 1 and s2n = 8. Find the shortest possible interval such that the posterior...

You should sell a stock that has a calculated value of $ 2 5 and is priced at $ 2 0

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...

5. Trainers or others in the company have the expertise (or the budget to purchase expertise from outside the company) to design and evaluate the data collected from an evaluation study.

3. The training program involves multiple classes and a large number of trainees.

6. To compare the costs and benefits of training versus nontraining investments (such as work redesign or a better employee selection system).