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

Books by authors from Poland

Combine the IN operator with a subquery that returns the ids of authors from a chosen country.

Task

Write a query that retrieves from the ksiazki table the tytul column of those books whose autor_id is on the list of author ids from the autorzy table coming from the country 'Polska'. Use the IN operator and a subquery.