I'm working on a database in a SQL Server, and below are the list of fields in my database. However, I have six questions that I need to build a SQL query and I was hoping someone can help me.

1. How many books are sold each month by the publisher?

2. Which authors are the biggest sellers of books in our stores?

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?

CUSTOMER ADDRESS AUTHOR PUBLISHER CATALOGUE ORDER BOOK CUSTOMER CUSTOMER NAME ADDRESSID PHONE EMAIL CITY STATE ADDRESSID ADDRESS1 ADDRESS2 AUTHOR NAME AUTHORID ADDRESSID CONTACT NAME AUTHORID PUBLISHERID PUBLISHER NAME ADDRESSID BOOK NAME PRICE ORDERID CATALOGUEID PUBLISHERID ORDER ID CUSTOMER ISBNID BOOKNAME YEAR PRICE ISBNID ZIPCODE CUSTOMER ADDRESS AUTHOR PUBLISHER CATALOGUE ORDER BOOK CUSTOMER CUSTOMER NAME ADDRESSID PHONE EMAIL CITY STATE ADDRESSID ADDRESS1 ADDRESS2 AUTHOR NAME AUTHORID ADDRESSID CONTACT NAME AUTHORID PUBLISHERID PUBLISHER NAME ADDRESSID BOOK NAME PRICE ORDERID CATALOGUEID PUBLISHERID ORDER ID CUSTOMER ISBNID BOOKNAME YEAR PRICE ISBNID ZIPCODE