$10.$ 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, book titles, publishers, and the years of publication. LO $4-2,$ LO $4-3$

$11.$ Ellen wants to know how many books each author wrote. Write a SQL statement to provide such information to Ellen. LO $4-2,$ LO $4-3$

$12.$ 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 to be sent to the customers. LO $4-2,$

LO $4-3$

$13.$ Ellen wants to know how many copies of each book were sold. Write a SQL statement to

obtain the necessary information you think Ellen wants. LO $4-2,$ LO $4-3$

$14.$ Ellen wants to know the dollar amount of total sales made on September $1,2017.$ Write a

SQL statement to obtain the necessary information you think Ellen wants. LO $4-2,$ LO $4-3$