i want only question 5-8 answered

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, LISBN), PK: (SSN, ISBN), FK: SSN refs Author, ISBN 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. 1000p E-DOXXmd 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) s. 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)