I'm working in a SQL Sever and below is a diagram of the tables in my database. I have a list of questions and I need help to write a SQL statements for.

1. How many books are sold each month by the publisher? This is important 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?

dbo Custome CUSTOMERID CUSTOMER NAME ADDRESSID CONTACT NAME EMALD dbo ADDRESS ADDRESSID ADDRESS ADDRESS2 STATE ZIPCODE VARCH AR120) VARCH ARIA VARCH AR120) VARCH ARI45) VARCH ARI45) VARCH AR120 VARCH ARE 45) VARCH AR(45) VARCH AR(50) CHAR12 CHAR15 dbo. PUBLISHER VARCH PUBUSHERID ARC20 VARCH PUBUSHER NNAME AR 45 VARCH CONTACT NAM AR(45 VARCH ADDRE AR(20 dbo ORDER ORDERID CUSTOMERID ORDATI ISBN dbo BOOK ISBN BOOKNAMI YEAR PRICE dbo AUTHOR AUTHOR NAME AURTHORID ADDR CONTACT NAME VARCH AR120) VARCH AR120) DATE VARCH AR45 VARCH AR120) VARCH AR45 VARCH AR(45 VARCH AR(20) VARCH AR(20) VARCH AR(4 dbo.CATOLOGUE VARCH CATALOGUEID AR120l VARCH BOOKNAM ARI45 NUMB PRIC RM8,21 VARCH PUBLISHID AR120 VARCH ORDERID AR120 dbo.AUTHORCATALOG VARCH AR(20 VARCH SBN AR(45