Excluding a Genre

Problem

A book club is looking for recommendations for their next book, but they want to avoid the "Fiction" genre this month. Find the title, genre, and price of all books where the genre is NOT "Fiction".

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