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.