Consider the following schema:

Publisher (name, phone, address), PK: name.

Book (ISBN, title, year, published_by, previous_edition), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book.

Author (SSN, first_name, last_name, address, income), PK: SSN.

Write(aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book.

Author_Editor(aeSSN, works_for), PK: aeSSN, FK: aeSSN refs Author, works_for refs Publisher.

Give relational algebraic expressions or SQL statements for the following plain English language queries based on the above schema.

19. p -
1. Provide the first name and last name of author-editors and the name and phone of the publishers that they work for. (15 pts)
2. Provide the ISBN of those books whose authors include both Andy Smith and Mary Doe. (15 pts)
3. Provide the ISBN of those books that have an author whose last name is Smith but do not have a coauthor whose last name is Doe. (15 pts)
4. Provide the SSN of those authors who have coauthored at least one book with the author named Andy Smith. (10 pts)
5. Provide the SSN of those authors who have coauthored all the books written by Andy Smith. (10 pts)
6. Provide the ISBN of every book whose publisher is different from the publisher of its previous edition. (10 pts)
7. Provide the SSN and the income of every author, as well as the name of the publisher that the author works for if he/she is also an editor. (15 pts)
8. Provide the title of the book that is the earliest book published by the publisher named ABC. (10 pts)