[Solved] Given tables Author, Book, and junction table AuthorBook with columns AuthorID and BookID, what does this query return?SELECT Author.Name, Book.Title FROM AuthorJOIN AuthorBook ON Author.... | SQL

SQL - Table Relationships

Given tables Author, Book, and junction table AuthorBook with columns AuthorID and BookID, what does this query return?

SELECT Author.Name, Book.Title FROM Author
JOIN AuthorBook ON Author.ID = AuthorBook.AuthorID
JOIN Book ON Book.ID = AuthorBook.BookID;

AA list of authors and the titles of books they wrote

BA list of books without any author names

CA list of all authors with all books, including unrelated pairs

DAn error because of missing WHERE clause

Step-by-Step Solution

Solution:

Step 1: Understand JOINs with junction table
The query joins Author to AuthorBook by AuthorID, then AuthorBook to Book by BookID, linking authors to their books.
Step 2: Result of the query
It returns pairs of author names and book titles where the author wrote the book, no unrelated pairs included.
Final Answer:
A list of authors and the titles of books they wrote -> Option A
Quick Check:
JOINs with junction table = related pairs only [OK]

Quick Trick: JOIN junction table to get related pairs only [OK]

Common Mistakes:

MISTAKES

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given tables Author, Book, and junction table AuthorBook with columns AuthorID and BookID, what does this query return?