The Marketing Department of JustLee Books is preparing for its annual sales promotion. Each customer who places
Question:
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 book’s retail price. JustLee Books also participates in coop advertising programs with certain publishers. If the publisher’s name is included in advertisements, JustLee Books is reimbursed a certain percentage of the advertisement costs. To determine the projected costs of this year’s sales promotion, the Marketing Department needs the publisher’s name, profit amount, and free gift description for each book in the JustLee Books inventory. Also, the Marketing Department is analyzing books that don’t 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.
Step by Step Answer: