Consider the following schema: Publisher (name, phone, address), PK: name. Book
ID: 672468 • Letter: C
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