Write Query Based Books Table Retrieve Title Month Published Books Published Calendar Yea Q28959979

BOOKS Table Name Null Type NOT NULL VARCHAR2 (10) ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY VARCHAR2 (30) DATE NUMBER (2) NUMBER (5,2) NUMBER (5,2) NUMBER (4,2) VARCHAR2(12) Chegg Study TEXTBOOK SOLUTIONS EXPERT ORA 053031150MINUTES A DAY 21-JAN-0S 0401140733 REVENGE OF MICKEY 4981341710 BUILDING A CARWTH TOOTHPICKS 18-MAR-08 8843172113 DATABASE IMPLEMENTATION 3437212490 COOKING MITH MUSHROOMS 3957136468 HOLY GRAIL OF ORACLE 1915762492 HANDCRANKED COMPUTERS 9959789321 E-BUSINESS THE EASY WAY 2491748320 PAINLESS CHILD-REARING 0299282519 THE WOK WAY TO COOK 8117949391 BIG BEAR AND LITTLE DOVE 08-NOV-05 0132149871 HOW TO GET FASTER PIZZA 9247381001 HOW TO MANAGE THE MANAGER 09-MAY-03 2147428890 SHORTEST POEMS 18.75 14.2 (nun FITNESS (null) FAMILY LIFE 30.95 14-DEC-05 3 CHILDREN (null) COMPUTER (null) cooKING 2 378 59.95 3 31.4 55.95 4 12.5 19.95 3 47 25 75.95 25 379 545 48 89.95 19 28.75 532 895 4 1785 29.95 1 15431.95 5 21.85 39.95 28-FEB-04 31-DEC-05 21-JAN-05 01-MAR-06 17-JUL-04 11-SEP-04 3 8 COMPUTER (nu) COMPUTER (null) COMPUTER 3 218 45 FAMILY LIFE (nuln cooKING (null) CHILDREN 1.5 SELF HELP (null) BUSINESS (null) LITERATURE 11-NOV-06 01-MAY-05 FIGURE A-4 Data in the BOOKS table

A.) Write a query based on the BOOKS table which will retrievethe title and month published for all books which were published inthe calendar year 2001. Arrange the list in chronological order bydate published. Do not use any logical operatorsin your query.

B.) Write a query based on the BOOKS table which will retrieveall book titles that are in the Business or Computer category andhave a retail price of more than $35.00.

C.) Write a query which will determine the price of the mostexpensive book in the books table.

D.) Write a query based on the BOOKS table which will display acategory and the average profit for books within that category.Profit is the difference between the retail price and the cost.

E.) Write a query based which will determine the number of bookswhich have been shipped in each category. Identify (list) thecategory in the output.

F.) Write a query which will determine the number of categoriescontained in the BOOKS table.

BOOKS Table Name Null Type NOT NULL VARCHAR2 (10) ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY VARCHAR2 (30) DATE NUMBER (2) NUMBER (5,2) NUMBER (5,2) NUMBER (4,2) VARCHAR2(12) Chegg Study TEXTBOOK SOLUTIONS EXPERT ORA 053031150MINUTES A DAY 21-JAN-0S 0401140733 REVENGE OF MICKEY 4981341710 BUILDING A CARWTH TOOTHPICKS 18-MAR-08 8843172113 DATABASE IMPLEMENTATION 3437212490 COOKING MITH MUSHROOMS 3957136468 HOLY GRAIL OF ORACLE 1915762492 HANDCRANKED COMPUTERS 9959789321 E-BUSINESS THE EASY WAY 2491748320 PAINLESS CHILD-REARING 0299282519 THE WOK WAY TO COOK 8117949391 BIG BEAR AND LITTLE DOVE 08-NOV-05 0132149871 HOW TO GET FASTER PIZZA 9247381001 HOW TO MANAGE THE MANAGER 09-MAY-03 2147428890 SHORTEST POEMS 18.75 14.2 (nun FITNESS (null) FAMILY LIFE 30.95 14-DEC-05 3 CHILDREN (null) COMPUTER (null) cooKING 2 378 59.95 3 31.4 55.95 4 12.5 19.95 3 47 25 75.95 25 379 545 48 89.95 19 28.75 532 895 4 1785 29.95 1 15431.95 5 21.85 39.95 28-FEB-04 31-DEC-05 21-JAN-05 01-MAR-06 17-JUL-04 11-SEP-04 3 8 COMPUTER (nu) COMPUTER (null) COMPUTER 3 218 45 FAMILY LIFE (nuln cooKING (null) CHILDREN 1.5 SELF HELP (null) BUSINESS (null) LITERATURE 11-NOV-06 01-MAY-05 FIGURE A-4 Data in the BOOKS table Show transcribed image text

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.