During an afternoon at work, you receive various requests for data stored in the database. As you
Question:
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.
Expert Answer:
