Filtering Multiple Genres

Problem

A customer is browsing the library and wants to see only books that are either "Fiction" or "Sci-Fi". Retrieve the title and genre of these books using the IN operator.

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