Consider the following schema: Publisher (name, phone, address), PK: name. Book

Question

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.

8. Provide the title of the book that is the earliest book published by the publisher named “ABC”.

Explanation / Answer

select top 1 b.title from

Book b

where b.published_by = "ABC"

order by year ASC

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.