Put in order · SQL and MySQL course · Module 7: Joining tables (JOIN)

A query joining books with authors

Arrange the parts of a table-joining query in the correct order (top to bottom, as we write them in the editor):

Items to put in order

  • ON k.autor_id = a.id;
  • FROM ksiazki k
  • INNER JOIN autorzy a
  • SELECT k.tytul, a.nazwisko

You can check the correct answer by solving this task in the CodeWorlds game.