Question
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.
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 MaxretaiStep 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