Instruction: In order to do this assignment, you need to create tables and populate data into the tables created (such as CUSTOMERS, BOOKS tables and identify their column names and data types). You are also required to include SQL statements (DDL and DML) in the report.

During the course of an afternoon at work, you receive various requests for data stored in the database. As each request is completed, you decide to document the SQL statements used to obtain the data so each person will know how the results were obtained. The following are two of the requests that were made:

1. One of the managers at JustLee Books requests a list of the titles of all books that generate a profit of at least $10.00. it is preferred that the results be listed in descending order, based upon the profit returned by each book.
2. One of the customer service representatives is trying to identify all books that are either in the Computer or Family Life Category and were published by Publisher 1 or Publisher 3. However, the results should not include any book that sells for less than $45.00.

For each request, present your report by identifing the SQL statement used to generate the needed data and provide the results of query.