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.