Question
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
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 the necessary SQL statements, and the output requested by the Marketing Department.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started