Finding Missing Publishers

Problem

An intern in the library inventory team noticed that some newly imported books don't have a publisher assigned yet. Retrieve the title and published_year of all books in the books table where the publisher_id is missing (NULL).

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