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.