Coding task · SQL and MySQL course · Module 8: Subqueries

Books outside poetry

Use the NOT IN operator with a subquery returning the ids of the Poezja category.

Task

Write a query that retrieves from the ksiazki table the tytul column of those books whose kategoria_id is NOT on the list of category ids named 'Poezja' from the kategorie table. Use the NOT IN operator and a subquery.