Put in order · SQL and MySQL course · Module 8: Subqueries
An IN subquery for Greek authors
Arrange (top to bottom) the lines of the query that retrieves books by authors from Greece using IN and a subquery:
Items to put in order
- SELECT id FROM autorzy WHERE kraj = 'Grecja'
- WHERE autor_id IN (
- SELECT * FROM ksiazki
- );
You can check the correct answer by solving this task in the CodeWorlds game.