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$