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.