Coding task · SQL and MySQL course · Module 8: Subqueries
Books by authors from Greece
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 all columns of books whose autor_id is on the list of author ids from the autorzy table coming from the country 'Grecja'. Use the IN operator and a subquery.