The Marketing Department of JustLee Books is about to begin an aggressive marketing campaign to generate sales
Question:
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’s request.
Step by Step Answer: