During an afternoon at work, you receive various requests for data stored in the database. As you fulfill each request, you decide to document the SQL statements you used to find the data to assist with future requests. The following are two of the requests that were made:The managers and CIOs are requesting a list of the titles of all books generating a profit of at least $30.00 (should include $30). The manager wants the results in descending order based on each books profit.The report's title and profit column headers should be displayed as "Profitable Books" and "Profit" for the managers to clearly interpret and understand the report.(Hint: Use aliases, and descending clause)  --50 pointsA sales department director wants to identify all books in the Literature or Business category and published by Publishers 1,3 or 5. However, the result should not include any books selling for more than $35.00  --50 pointsDetermine the SQL statements needed to perform the two required tasks. Each statement should be tested to ensure validity. 

 

S Connections ts Worksheet Query Builder select from books Query Result x ISBN SQL | All Rows Fetched: 14 in 0.005 seconds TITLE PUBID COST RETAIL DISCOUNT CATCODE (null) CATEGORY 4 18.75 30.95 (null) FITNESS 1 14.2 2 37.8 59.95 1059831198 BODYBUILD IN 10 MINUTES A DAY 21-JAN-05 20401140733 REVENGE OF MICKEY 14-DEC-05 18-MAR-06 04-JUN-03 3 31.455.95 (null) COMPUTER 28-FEB-04 4 12.5 19.95 (nul1) COOKING 31-DEC-05 3 47.25 75.95 3.8 COMPUTER 21-JAN-05 3 21.8 25 (null) COMPUTER 01-MAR-06 2 37.9 54.5 (null) COMPUTER 17-JUL-04 5 48 89.95 4.5 FAMILY LIFE 11-SEP-04 4 19 28.75 (null) COOKING 08-NOV-05 5 5.32 8.95 (null) CHILDREN 11-NOV-06 4 17.85 29.95 1.5 SELF HELP 09-MAY-03 1 15.431.95 (null) BUSINESS 22 (null) FAMILY LIFE (null) 3 CHILDREN (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) PUBDATE 3 4981341710 BUILDING A CAR WITH TOOTHPICKS 48843172113 DATABASE IMPLEMENTATION 53437212490 COOKING WITH MUSHROOMS 63957136468 HOLY GRAIL OF ORACLE 71915762492 HANDCRANKED COMPUTERS 89959789321 E-BUSINESS THE EASY WAY 92491748320 PAINLESS CHILD-REARING 10 0299282519 THE WOK WAY TO COOK 11 8117949391 BIG BEAR AND LITTLE DOVE 12 0132149871 HOW TO GET FASTER PIZZA 13 9247381001 HOW TO MANAGE THE MANAGER