What are the most popular products besides books that are sold in each store?

because quantity discounts are available from the publisher.
2. Which authors are the biggest sellers of books in our stores? This is important because the publisher offers discounts for certain authors each month.
3. What books are associated with each publisher?
4. What are the most popular products besides books that are sold in each store? In addition to books, the stores sell magazines, café-specific products like
coffee and pastries, and various gift products.
5. From what region(s) (by ZIP code) do customers visit our stores? This is important because it will assist with future marketing efforts.
6. What customer data must be stored for the e-commerce portion of the website?