Matching Books with Authors

Problem

A reader wants a list of books along with the names of their authors. Write a query to retrieve the book title and the author's name from the books and authors tables.

Database Schema

Table: publishers

• id (INT): Unique identifier for the publisher.
• name (VARCHAR): Name of the publisher.
• country (VARCHAR): Country of the publisher.

Table: authors

• id (INT): Unique identifier for the author.
• name (VARCHAR): Full name of the author.
• country (VARCHAR): Country of origin.
• birth_year (INT): Birth year of the author.

Table: books

• id (INT): Unique identifier for the book.
• title (VARCHAR): Title of the book.
• author_id (INT): Foreign key referencing the author.
• publisher_id (INT): Foreign key referencing the publisher.
• published_year (INT): The year the book was published.
• price (DECIMAL): Book price.
• genre (VARCHAR): Genre of the book.

Try It

Hint

Solution