Q$1.$ Ellen asks you to give her a list of the books that each author wrote. Write a complete SQL statement

to provide the information to Ellen, including author names $($last name and first name$),$ book titles,

publishers, and the years of publication.

Q$2.$ Ellen wants to know how many books each author wrote. Write a SQL statement to provide such

information to Ellen, including author names $($last name and first name$)$ and the number of books each

author wrote.

Q$3.$ You are going to send emails to inform the customers that the books ordered have been shipped.

Write a SQL statement to obtain the complete information on the book title$($s$),$ unit price$($s$),$ and the

number of each book purchased by each customer $($last name, first name, and Email$).$

Q$4.$ Ellen wants to know how many copies of each book were sold. Write a SQL statement to obtain the

necessary information, including book titles, publishers, the years of publication, and the number of

copies sold.

Q$5.$ Ellen wants to know the dollar amount of total sales made on September $1,2020.$ Write a SQL

statement to obtain the necessary information, including the sales date, and the total dollar amount of

sales.