Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions