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.
Step by Step Answer: