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.