As mentioned, we have a total of 15 stores in London.
The marketing team would like to know the average revenue generated by each store before selecting the stores for the direct marketing campaign.
Let's find out how much revenue each store generated in the first quarter of 2017.
Did the code fail?
Copy and run the code below to create the input data sets.
This gives you a summary of the total sales for each store:
Management has selected the following three stores for our direct marketing campaign:
Let's create a new table that stores the targeted stores:
