(Solved) : Consider Following Schema Publisher Name Phone City Pk Name Book Isbn Title Year Published Q32603744 . . . .

Consider the following schema:

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

Book (ISBN, title, year,published_by, previous_edition, price), PK: ISBN, FK: published_byrefs 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.

Editor (SSN, first_name, last_name,address, salary, works_for, book_count), PK: SSN, FK: works_forrefs Publisher.

Edit (eSSN, bISBN), PK: (eSSN,bISBN), FK: eSSN refs Editor, bISBN refs Book.

Author_Editor (aeSSN, hours), PK:aeSSN, FK: aeSSN refs Author, aeSSN refs Editor.

Give SQL statements for the following plain English languagequeries based on the above schema.

1.Show the number of books publishedin 2008 versus the number