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 SELECT FROM books WHERE retai... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c1212744a_716441.pdf
180 KBs PDF File
1803_60b8c1212744a_716441.docx
120 KBs Word File
