Ellen Novotny started an online bookstore in 2017. You are Ellen's best friend and promised to help her. Ellen asked you to create a small database to track the information on books and authors. You created the following tables: Author, Book, and Author_Book. The table Author_Book is a relationshlp table to link the Author table and Book table because of the many-tomany relationship between the two tables. That is, each author may write many books and each book may have multiple authors. In general, each customer can purchase many books in a single transaction. Also, copies of the same book can be sold to different customers. Once an order is processed, the books are shipped right away. Based on these tables you have (see below), help Ellen to extract the information she needs from the database. Author Book Author_Book Customer Sales_Line_Item Required: (1) Ellen asks you to give her a list of the books that each author wrote. Use Query Design or write a complete SQL statement to provide the information to Ellen, including author names, book titles, publishers, and the years of publication. Name the query as "Requirement 1 ". (2) Ellen wants to know how many books each author wrote. Use Query Design or write a SQL statement to provide such information to Ellen. Name the query as "Requirement 2". (3) You are going to send emails to inform the customers that the books ordered have been shipped. Use Query Design or write a SQL statement to obtain the complete information on the book title(s), unit price(s), and the number of each book purchased to be sent to the customers. Name the query as "Requirement 3 ". (4) Ellen wants to know how many copies on each book were sold. Use Query Design or write a SQL statement to obtain the necessary information you think Ellen wants. Name the query as "Requirement 4". (5) Ellen wants to know the dollar amount of total sales made on September 1, 2020. Use Query Design or write a SQL statement to obtain the necessary information you think Ellen wants. Name the query as "Requirement 5