Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To perform the following activity, refer to the tables in the JustLee Books database. The Marketing Department of JustLee Books is about to begin an

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

The Marketing Department of JustLee Books is about to begin an aggressive marketing campaign to generate sales to repeat customers. The strategy is to look at existing customers previous purchases, and based on the categories from which these customers have made purchases, JustLee Books will send promotional information about other books in the same category that are highly profitable books for the company. The Marketing Department has requested that you identify the five most frequently purchased books and the percentage of profit each book generates. The percentage of profit can be calculated by using the formula ((retail-cost)/cost*100). The employees in the Marketing Department will use the potential profitability of the marketing campaign to determine how much money to budget for the campaign.

Provide an SQL statement along with the output to respond to the Marketing Department request.

image text in transcribed

ORDERS CUSTOMERS Order# Customer Customer Orderdate Lastname Shipdate Firstname Ship street Email Shipcity Address Shipstate City Shipzip BOOKAUTHOR AUTHOR State BOOKS Shipcost Zip Author ID SBN SBN K AuthorID 7 Lname Referred ORDER ITEMS Region Title Frame Order# Pubdate PublD Item# Cost Quantity Retail Discount Paideach PUBLISHER Category PublD Name PROMOTION Contact hone Gift Minretai Maxretai ORDERS CUSTOMERS Order# Customer Customer Orderdate Lastname Shipdate Firstname Ship street Email Shipcity Address Shipstate City Shipzip BOOKAUTHOR AUTHOR State BOOKS Shipcost Zip Author ID SBN SBN K AuthorID 7 Lname Referred ORDER ITEMS Region Title Frame Order# Pubdate PublD Item# Cost Quantity Retail Discount Paideach PUBLISHER Category PublD Name PROMOTION Contact hone Gift Minretai Maxretai

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

Database Processing

Authors: David J. Auer David M. Kroenke

13th Edition

B01366W6DS, 978-0133058352

More Books

Students also viewed these Databases questions

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago