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

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.

Step by Step Solution

3.25 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 SELECT FROM books WHERE retai... View full answer

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

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212744a_716441.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212744a_716441.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!