Create reports containing the following details from the database: For EACH of the questions create TWO scripts, one using: a) traditional join with the WHERE clause AND another one using: b) ANSI join with the JOIN keyword Q1 List the book title, publisher name, contact, and contact phone number for all computer books with a retail price under $100. Q2 List all book titles and the first and last names of the customer(s) who ordered each title. Be sure to show the titles of the books that were not ordered. Q3 Use the MINUS operator to list the publishers who have not published any cooking books. The MINUS operator will make this much easier. Q4 List the ISBN, title, author last name(s), retail price, and the promotional gift for all books. For books with multiple authors list both author's names but it is also OK if only one was provided.

Q5. An EMPLOYEES table was added to the JustLee Books database to track employee

information. Display a list of each employees name, job title, and managers name. Use

column aliases to clearly identify employee and manager name values. Include all

employees in the list and sort by manager name.

Q6 To perform this activity, refer to the tables in the JustLee Books database.

The Marketing Department of JustLee Books is preparing for its annual sales promotion.

Each customer who places an order during the promotion will receive a free gift with each book

purchased. Each gift will be based on the books retail price. JustLee Books also participates in

co-op advertising programs with certain publishers. If the publishers name is included in

advertisements, JustLee Books is reimbursed a certain percentage of the advertisement costs.

To determine the projected costs of this years sales promotion, the Marketing Department

needs the publishers name, profit amount, and free gift description for each book in the JustLee

Books inventory.

Also, the Marketing Department is analyzing books that dont sell. A list of ISBNs for all

books with no sales recorded is needed. Use a set operation to complete this task.

Create a document that includes a synopsis of these requests, the necessary SQL

statements, and the output requested by the Marketing Department.

FIGURE 1-5 JustLee Books's table structures after normalization