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:
1. A manager at JustLee Books requests a list of the titles of all books generating a profit of at least $10.00. The manager wants the results listed in descending order, based on each book’s profit.
2. A customer service representative is trying to identify all books in the Computer or Family Life category and published by Publisher 1 or Publisher 3. However, the results shouldn’t include any book selling for less than $45.00. For each request, create a document showing the SQL statement and the query results.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: