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

A loan report from three tables

Arrange the parts of a query joining three tables (wypozyczenia, czytelnicy, ksiazki) in the correct order (top to bottom):

Items to put in order

  • INNER JOIN ksiazki k ON w.ksiazka_id = k.id;
  • INNER JOIN czytelnicy c ON w.czytelnik_id = c.id
  • SELECT w.data_wypozyczenia, c.nazwisko, k.tytul
  • FROM wypozyczenia w

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